Learn
Learn
Support
Support
Product
Community
Partners

Community
Discussion ForumsFinancials 1333 Distribution 1329 Manufacturing450 Construction426 CRM78 Field Service188 Retail-Commerce345 Payroll163 Low Code | No Code Customizations or Integrations117 Develop Customizations1910 Develop Integrations with Web Services | APIs403 Other Developer Topics103 ISV Solutions 107 Configuration and Installation 585 Reports and Generic Inquires 1282 Import and Export Scenarios 498 System Health and Performance 106 Community site discussions167 Community Introductions72 Everything Else 593
News & AnnouncementsAcumatica News & Updates94 Events & Meet-ups122 Developer Newsletter 19 Newsletter 33

Create topic
Login

Community
Discussion Forums
Distribution

Distribution

Inventory, Orders Management, Warehouse Operations

1,329 Topics
5,143 Replies

When you subscribe we will email you when there is a new topic in this category

1329 Topics

Recently active

Most replies Most views Newest first

john25Freshman I

asked in Distribution

dmaxwellFreshman I

asked in Distribution

Vendor Cost

Is it possible for a given item from a given vendor to have different costs based on the vendor warehouse or plant? i.e. vendor X has multiple locations A and BItem Y from Vendor X, location A has a cost of ‘a’Item Y from Vendor X, location B has a cost of ‘b’ Any insight, greatly appreciated.Thanks,Dave

1 year ago

john25Freshman I

asked in Distribution

Customer Info

We get these credit referances all the time to fill out on account in good standing and avg days to pay, largest invoice etc. for one of our customers. Is there a report that shows this info? ThanksJohn

1 year ago

dales50

asked in Distribution

Scales / Device Hub and Warehouse Managment

Device Hub is configured with local usb scale and weight is displayed, Acumatica is seeing the scale on he Scale screenItem is set to manual pack with a weight.When confirming a package with the item in WMS / Pack the system is using the weight of the product.How can you configure to have the package weight pulled from the scale and not use the item weight

1 year ago

kudzaim20Freshman II

asked in Distribution

Sales invoice Import template speed taking 6hrs to import 2500 record lines

I am importing invoices into screen SO303000 and I have 2,500 record lines and this is taking about 6 hours, previously I would import this in under an hour using the same template.What could be the issue?

1 year ago

Jp89

asked in Distribution

Is there an area on the site where Customer Complaints about the software can be shared?

1 year ago

idrusm52Jr Varsity II

asked in Distribution

Forget to do Update IN make item still have On Hand without availability

My staff forgot to do Update IN during Shipment process then accounting continue to do invoicing make the item still have Qty On Hand.Please advise how to create an Issues to make QOH zero without having ‘Available for Issue’. Thanks,Idrus

1 year ago

brothe58Freshman I

asked in Distribution

Restocking the Default Issue From location in combination with FIFO issue method

I’m currently upgrading to 21r2. I have a business need for a warehouse restocking report. This is different than a replenishment or purchasing report.My goal is to make it so a warehouse picker never arrives at an empty Default Issue From location because it’s already been refilled by restocker. FIFO must be factored, when applicable.Consider an example Inventory ID `12345` that is Lot Tracked with a FIFO issue method. This item is stored in 4 different locations within a single warehouse:Location IDs for `12345`:——————PRIMARYPICK — Default Issue From location (this is where we pick from)STORAGE1 — Lot #3 (newest inventory)STORAGE2 — Lot #2 (older inventory)STORAGE3 — Lot #1 (oldest inventory)I need a report (or generic inquiry) to tell my restockers to refill the PRIMARYPICK for `12345` *before* the inventory runs out. It needs to direct them to the correct Location ID that should be used for restocking the PRIMARYPICK. In the example above, this would be STORAGE3 because it’s the ol

1 year ago

ptreske76Freshman I

asked in Distribution

Shared E-Mail Inbox Causing Duplicate Sales Orders To Be Input - Warning Inadequate

Hello,Our company has finally joined the 21st century and is using a shared inbox instead of having customers directly message “their favorite” internal sales person their purchase order. The problem we have been running into is that since multiple people are processing orders from a shared inbox, orders are being duplicated.While one could argue that there is a prevention system for this within Acumatica, I’m going to argue against that. This is the only warning you receive and it is completely inadequate. There are so many little yellow warnings all over everything on every single screen it becomes just another part of “warning fatigue.” We need a very obvious pop-up note or something to make the person entering the order re-think and check to see if the order has already been input.I realize that “Nathan” is not a proper PO number, however, sometimes you’ll just get a customer that calls or sends over an e-mail and says just use “Nathan” or “Verbal Nathan” as my PO for this order

1 year ago

stacy16Varsity I

asked in Distribution

Non-stock types

Can anyone explain to me the difference between the non-stock types?LaborServiceChargeExpenseI know what they mean but do they each serve a different purpose functionality wise?Thanks!

1 year ago

sysuser113Freshman I

asked in Distribution

Import scenario to retrieve unique records based on Order Nbr. field

I need to import the unique sales Order records from Database table to Prepare Invoices.How to use “SOURCE RESTRICTION” in this case.?

1 year ago

frankfiorentino81Jr Varsity II

asked in Distribution

Uploading physical inventory account from an excel file

I have a client that used an excel file to upload their physical count twice which had an additive effect. The Common Settings dialog box for uploading the count does not look like the dialog box used with other excel based uploads in that it does not include the ability to change the mode. I checked the help documentation and it clearly states that the mode can be changed. Is this a recent change or a bug?

1 year ago

ckwiat46Jr Varsity II

asked in Distribution

Need help in Confirmation Dialog

Hello, on Purchase Receipt Release action, we need to show user a Confirmation Dialog, then based on the input from first Confirmation Dialog, we need to show another Confirmation Dialog popup. On release action first Confirmation Dialog appears but not the second one. Please have a look at below code and suggest me what wrong am doing here. public virtual IEnumerable Release(PXAdapter adapter){if (Base.Document.Ask("Confirmation Dialog 1", MessageButtons.YesNo) != WebDialogResult.Yes) return adapter.Get();elseif (Base.Document.Ask("Confirmation Dialog2", MessageButtons.YesNo) != WebDialogResult.Yes) return adapter.Get();}

1 year ago

dsenevirathne54Freshman II

asked in Distribution

Sales Price Import Scenario is not Working

HI, We have created a Sales Price Import Scenario and It was not worked as we expected. As reference we have attached the Import scenario. RegardsDulanjana

1 year ago

mpeck12Freshman II

asked in Distribution

Employee and Vendor

In the case where an employee sometimes is reimbursed for Employee expenses (Travel, Living, Lodging and Entertainment come to mind) but also provides services which are not part of their employment contract, i.e. Advertising.When entering the bills for these activities, is there a way to indicate for each item whether it is reportable as a 1099 reportableactivity as opposed to an employee expense re-imbursement, which would not be considered income, and should not be reported on a 1099.

1 year ago

Nelson YipJr Varsity III

asked in Distribution

Top Selling Item

Hello,Is there a report to check to see the top selling items by month?

1 year ago

NAthukorala47Jr Varsity III

asked in Distribution

How to Remove Inventory Allocation Transactions

Hi, Need to remove Inventory following allocation transaction. Actual Transaction is not showing this. But it is showing Inventory Balance Report. No need to show this Item. We disallow Item Negative balance in item class Level. Inventory Balance Report Item Class Level.

1 year ago

clancourFreshman II

asked in Distribution

Process Shipments - Update IN-Confirmed Not Billable action removed in 2020R2+

Customer upgraded from 2019 recently and the highlighted item below “Update IN – Confirmed not billable” is what he used to select when processing sales orders that did not need to be billed (such as when you send out a sample shipment to a customer). Does anyone know if this has been replaced or why this is no longer there? Is there another way to have these items selected when processing shipments?I confirmed it’s in 2020R1, not in 2020R2. Nothing in the initial release notes for 2020R2.D100 training references it 2020R1 as well, and not in 2020R2. Oddly enough, the documentation still mentions the action: “Update IN - Confirm Not Billable: To generate inventory documents for shipments made for transfer orders and returns with replacements.”Thx!-Chad» Screenshot from 2020R1

1 year ago

NAthukorala47Jr Varsity III

asked in Distribution

Need to create PO using multiple PRs

Hi, We need to create Purchase Order using Multiple Requisitions. Ex: Need to create Purchase order as Follows. Need to orderItem A from PR-No 01 and PR-No-02 =150 QtyItem B from PR-No 01 and PR-No-02 =210 QtyHow can we merge multiple PRs in One PO? RegardsNethupul

1 year ago

JEFSMIFreshman I

asked in Distribution

Field Above or Below Child Grid

I have a custom screen that has a parent/child standard editing form similar to sales orders in how it looks.Under the child grid or above it, I'd like to put a control that is bound to the same table/field as the child grid.It works to show the initial record's value from the child grid, but as I select different rows in the child grid it doesn't refresh with the proper values. It always shows/edits the first value from the grid. Is there any way to get the control to show the right value from the grid and work like this?I realize I can put in the edit mode for the grid, but for ease of use this one field (multi-line HTML Editor) really needs to just allow the user to click on the row and edit the value easily. Edit: Sorry this somehow posted to distribution. Should have been in Customizations but I can’t figure out how to move it!

1 year ago

hmarambioFreshman I

asked in Distribution

Automation Schedule (Task) - Elapsed time from Start to Completion?

Hey folksMy ultimate goal is to have the ability to DAISY CHAIN Automated Schedules (tasks) much like you can do via SQL (SMSS). As far as I can tell the ability to daisy chain multiple tasks DOES NOT exist in Acumatica (within AUTOMATION SCHEDULE). I have the need properly launch multiple schedules tasks that are dependent on each other. I need to know start and end time of a given task in order to do this correctly since daisy chain is NOT an option. How do I display FINISH time in either the AUTOMATION SCHEDULE STATUSES and AUTOMATION SCHEDULE HISTORY screens? The ability to daisy chain tasks would be great for Acumatica to have, I’ll create an idea assuming that the functionality doesn’t currently exist. Anybody got any bright ideas on how to handle?

1 year ago

aaronthomas82Freshman II

asked in Distribution

Customer Sales Summary Report

I am looking to create a customer sales summary report where sales are summarized by year. Column heading as follows:Customer #, Customer Name, 2022 Sales, 2021 Sales, 2020 SalesSales are define as Sales Order Invoices.

1 year ago

Page 42 / 54

Badge winners

jininhas earned the badge Low Code | No Code Customizations or Integrations
Kyle Vanderstoephas earned the badge Easy talker
NuwanTharanga62has earned the badge Financials expert
jaysonhas earned the badge Easy talker
palboreshas earned the badge Easy talker

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Social Login

Login to the community

Social Login

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

About Acumatica ERP system

Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.

Privacy Policy
Terms of Use
GDPR
SLA
Support
Report an Outage