AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

alconroy
alconroy
@alconroy
Forum Home   |   Recent Posts
Eminent Member
Follow
Profile Activity
Topics: 1 / Replies: 30
AllTopicsReplies
Reply
RE: Purchase Receipt Creation skips every other line with Import Scenario

Have you tried it without the <Save> in the middle of the scenario?

2 months ago
Forum
Everything Else
Reply
RE: What Happens If the “Create Bill” Checkbox Is Left Unchecked in a Purchase Receipt?

If you leave it blank, when you receive the invoice from the vendor you can then create a Bill for the invoice and add the PO receipt to the Bill to m...

4 months ago
Forum
Everything Else
Reply
RE: Adding Side Panels to Data Entry Screens

@david-eichner I have seen it where the user no longer has permission to see the GI that side panel is using

9 months ago
Forum
Everything Else
Reply
RE: Create new field in PO with default values

try lower cases on your fields [PXDefault(typeof(Select<PMProject, Where<PMProject.contractID, Equal<Current<POOrder.projectID>&g...

10 months ago
Forum
Everything Else
Reply
RE: Simple Business event not triggering

For business events to trigger you need the key fields for each table in the results. I see you are using the stock item PL which from experience has ...

11 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Switch off ability to backorder / oversell at SKU Level

I did something similar a while back, from memory... we did a custom boolean (check) box to flag the items which were end of life. When the stock leve...

11 months ago
Forum
Everything Else
Reply
RE: Adding ETA field to purchase orders

at a very simple level you could add in an ETA attribute and then add that to the PO under the Manager User Defined Fields option

11 months ago
Forum
Acumatica Report Designer
Reply
RE: Linking File attachment comments to a GI

Join ARTRAN to NOTEDOC on the noteid fields Join NOTEDOC to UploadFileRevisionNoData on the file id fields.

11 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Busniess Event to add an SO line

You need to have all the details you want to import in the GI you are using for the business event, and also there needs to be a <Line Number> -...

11 months ago
Forum
Everything Else
Reply
RE: Acumatica Data Provider

I am normally pushing from Acumatica to an external SQL database, this is my setup, note the port number on the server record.

1 year ago
Forum
Everything Else
Reply
RE: Create a Generic Inquiry to Show only Orders with Specific Inventory Items

Join SOOrder to SOLine and SOLine to InventoryItem You can then set a condition the InventoryCD starts with 6 You could also add an attribute ...

2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Adding custom field to Appointments screen

You'd need to add a custom field for to the service order says UsrEquipLocation and then add an event handler like Row Persisted to Field Updating on ...

2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Adding custom field to Appointments screen

You need to add the field in the Service Order Details Grid. See screenshot below

2 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Sequential Business Events

It might depend on your screen but say you add 3 custom Boolean field BE1,BE2 & BE3 The first business event then checks BE1, the second busine...

2 years ago
Forum
Everything Else
Reply
RE: Item Class reporting based on parent class

How does your report requirement differ to AR674000 when run in summary?

2 years ago
Forum
Acumatica Report Designer
Reply
RE: Exporting a report in .txt format

You could probably look at doing an export scenario into a text or csv file and send that by email with a business event when an new invoice is genera...

2 years ago
Forum
Everything Else
Topic
Getting a SUM from Quantity on Report
2 years ago
Forum
Acumatica Dashboards
Replies: 1
Views: 1165
Reply
RE: GI Duplicate Lines

your join to aptran is wrong you need to join it to the poreceiptline not the poreceipt this will give you the joins necessary in the outgoing ref...

3 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Shipment Delete Icon

You'll find it under shipments in sales orders, drill down sales orders >> shipments >> shipment See image attached

3 years ago
Forum
Everything Else
Reply
RE: Acumatica Schema Browser from Juriy

@rickyg75 make sure in the site map it has a workspace and category and it should appear for you then

3 years ago
Forum
Everything Else
Reply
RE: Acumatica Schema Browser from Juriy

@rickyg75 it was a useful tool but it has been replaced by the dac browser now See/p>

3 years ago
Forum
Everything Else
Reply
RE: Help to tie Freight Cost to Sales Orders when invoice arrives

I did something very similar for dropship orders (sorry I can share the GI at the moment) The links were SOOrder to SOOrdershipment SOOrdership...

3 years ago
Forum
Accounting in Acumatica
Reply
RE: Acumatica Processing Payments

try grouping by check number and then select max aggregate function for check amount on the results grid

3 years ago
Forum
Acumatica Report Designer
Reply
RE: Adding Side Panels to Data Entry Screens

@lweinstein yes it does

3 years ago
Forum
Everything Else
Reply
RE: Adding Side Panels to Data Entry Screens

Export the customisation project first before you change it, make you changes and if anything goes wrong, unpublish your project, delete it and then i...

3 years ago
Forum
Everything Else
Reply
RE: Upgrading Generic Inquiries & Pivot Tables

Interesting idea Tim, Notepad ++ has a compare plugin which you can use to see the changes. Here is a partial screenshot of some changes in a PO GI...

3 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Account class infor linked it to Aptran

Link APTran to GL.Account Parent & Child fields are both AccountID

3 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Report Designer Error

Try running the report designer as administrator and see if that works. Othewise you may have to remove & reinstall the designer again

4 years ago
Forum
Acumatica Report Designer
Reply
RE: Adding GL Account info to Vendor Generic Inquiry

You are looking for the LocationExtAddress table Add that and join on the DefLocationID from vendor to the locationid table and you can add in t...

4 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Welcome and Introductions

@timrodman thanks Tim, one of the side effects of covid, the leap towards remote and collaborative technology allows me to do this, where as I would p...

4 years ago
Forum
Everything Else
Reply
RE: Welcome and Introductions

Hello AUG, greetings from [My area not listed] or Dublin, Ireland as its more commonly known 🙂 I have lurked on this board for a while and I have j...

4 years ago
Forum
Everything Else

Online Members

  • Nathan Deardorff
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.