Learn
Learn
Support
Support
Product
Community
Partners

Community
Discussion ForumsFinancials 955 Distribution 1036 Manufacturing343 Construction329 CRM1 Field Service144 Retail-Commerce271 Payroll121 Low Code | No Code Customizations or Integrations60 Develop Customizations1440 Develop Integrations with Web Services | APIs301 Other Developer Topics50 ISV Solutions 89 Configuration and Installation 438 Reports and Generic Inquires 932 Import and Export Scenarios 370 System Health and Performance 74 Community site discussions125 Community Introductions56 Everything Else 480
News & AnnouncementsAcumatica News & Updates80 Developer Newsletter 17 Newsletter 21

Create topic
Login

Community
Discussion Forums
Distribution

Distribution

Inventory, Orders Management, Warehouse Operations

1,036 Topics
4,010 Replies

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

1036 Topics

Newest first

Recently active Most replies Most views

edsonvelez64Jr Varsity II

asked in Distribution

How to use GS1 barcode in Acumatica?

Hi,What are the steps to configure or use the GS1 barcode in Acumatica? Any example? Thanks,EV

1 month ago

MarciaWVarsity I

asked in Distribution

Mass Action Access

For audit reasons, our system admins cannot do mass actions where transactions are involved. I need to allocate this access to a user, but I can’t seem to find any information on access when it comes to mass actions. Please point me in the direction on some documentation in this regard!

4 months ago

dsenevirathne54Freshman II

asked in Distribution

Link invoices to Sales Orders

Hi,Is there any possibility to link an already created AR invoice to a sales order, without creating AR invoice through sales order. Thanks,Dulanjana

5 months ago

K2aFreshman II

asked in Distribution

Duplicate Field to Header

Hello,I searched for this and couldn’t seem to find an exact hit.I’d like to duplicate the ‘default Sales Person’ from the Commissions tab on the sales order to the Header so that Sales Reps can see, overtly, who is being defaulted (and change it if necessary) at the header level instead of the Commissions tab.Is this achievable?Cheers,k2

5 months ago

claudematherne24Freshman I

asked in Distribution

Stock Item and Non-Stock Item notes populating into Purchase Order lines

Hello everyone, I’m trying to find a way to have the notes on a Stock or Non Stock item automatically print on a Purchase Order. I know I can add notes on the individual line, but I don’t want to have to manually copy the notes per line item for every time I make a PO. Use Case: For our ISO 9000 certification, I need the stock item note to call out a spec reference sheet every time I make a PO for that item.

5 months ago

stacy16Varsity I

asked in Distribution

adding a credit memo to a quote

Is there any way to reference a credit memo in a quote? We are offering a “credit” for a trade in stock item and want to be able to show that credit on the quote. Any ideas? Thanks in advance!

4 months ago

madhuFreshman II

asked in Distribution

How to solve the following error error: Physical Count in progress for ORJAM96 in warehouse "WholesaleL1R3S3'.

When i am trying to conform the shipment the above error has occurred, so can any tell me why the error was coming and what the solution for that error.

5 months ago

chidao

asked in Distribution

Access Right - how to allow user to access help open - form reference

HI All,Please advise which access right is allowed user to see the articles on open help (form reference)

5 months ago

lori00Freshman I

asked in Distribution

jparvezFreshman I

asked in Distribution

Cant Convert a Sales Quote to SO

Dear Community, I cannot convert a sales quote to a Sales order. The convert option is grayed out. Sales Quote Status is approved Business account is extended as Customer Am i missing any steps?

5 months ago

ltussing03Semi-Pro II

asked in Distribution

Automatic Update IN when shipping

I would have sworn there was a preference setting to cause the update IN transaction automatically occur when you enter a shipment.However, I cannot find it now.Can anyone point me to the correct preference setting?We don’t want to hit the “update IN” button every time we ship as it will certainly be forgotten at times.Thanks!

5 months ago

krausef77Jr Varsity II

asked in Distribution

Correct Shipment does not Reopen Confirmed Shipment

Good day everyone,We have a client who is experiencing issues with the function of correcting the Shipment.The Shipment was confirmed by Accident. No Billing or inventory transaction has been taken place.The Sales Order is Completed. When I try to recreate the problem in Sales Demo environment. (Same settings on Order type etc), it works.The User hits Correct Shipment (myself included in that environment) and it says the Operation was completed. Yet, the status doesn’t change to Open as it should: Anyone ever experienced this?

5 months ago

aidenwills15Freshman I

asked in Distribution

Vendor ID number generation

Is it possible for the vendor ID number to be auto generated with the first 3 letters of the vendor, a number to differentiate vendors with the same first 3 letters, and then a V at the end upon vendor creation?For example, when I add a vendor for West Side Materials, have the system automatically create the vendor ID WES001V. Then add Wesley’s Supplies Co. and have the system create the ID WES002V.Thank you all for your time!

5 months ago

NAthukorala47Jr Varsity III

asked in Distribution

Need to change the Sales and Purchasing Unit of Measure

HI, I have created a Item with UOM as CTN. I need to change this to BOX. I checked this, if I have any Transactions system allow me to change Sales and Purchasing Units. Then system created a conversion between both two unit of measures. Tested scenarios attached with screen shots. 01). As mentioned Item Base unit is “CTN” and Sales and Purchasing UOM are “BOX”.Created a sales order and Order line has taken UOM as BOX then Shipped. Shipping Lines Considered UOM as BOX. My Questions are:(01). If I change this over to a conversion rate of 1, and change the Unit of Measure, what will the implication be when we sell and purchase this item? Is it going to create a mess in the background with regard to the costs, or the average cost? (02). Is there any other validation or concerns about the UOM changes? RegardsNethupul

5 months ago

ely36Freshman II

asked in Distribution

batch number product in stock items

Hi, I want to ask , is it available for input batch number of product in stock items menu ?

5 months ago

acumaticapm182Jr Varsity II

asked in Distribution

How to populate the lotserial and expiry date per inventory ID in report designer

Hi all, How do I populate all the lot/serial number and expiry date per InventoryID in Report Designer like this: The lot/serial or expiry date need to display per InventoryIDThis is the value from expression editor (InventoryID Description field)=IIf([ARTran.InventoryID]<>Null, Format( '{1}', [ARTran.InventoryID],[ARTran.TranDesc]),[ARTran.TranDesc]) I found other topics from here in community and I followed their combination in Build Schema but it’s not working for me Link: (Print Batch/Lot no. and expiry date on invoice | Community (acumatica.com)) This is my build schema:I added the ARTran Left INLotSerialStatus table and the parent field belowINLotSerialStatus.inventoryID Equal ARTran.inventoryIDINLotSerialStatus.lotSerialNbr Equal ARTran.lotSerialNbr This is all my table: I think I missed a table to combine the relation. Can you help me with my concern? Thanks

5 months ago

anhthuy

asked in Distribution

business email

5 months ago

Nelson YipJr Varsity III

asked in Distribution

Storage Summary 2022R2 Search is broken

Storage Summary search filter is not working after upgrading to 2022 R2

1 month ago

scottjohnsonhereFreshman I

asked in Distribution

Error while trying to delete/remove a PO line that has been received then fully returned.

This may be a similar issue to canceling a PO that has been fully returned. We have a PO with multiple lines. One line was received then fully returned. While attempting to delete that line, the following error message appears. “PO Error: The line cannot be deleted because some quantity of an item in this line have been received.”I am aware of trying to cancel a PO that has been received and the solution of setting it to complete. Just curious if this is a similar issue but on the line level and if the solution is to complete the line instead of delete. Thanks!

5 months ago

lukef55Freshman I

asked in Distribution

Reverse Credit Memo with Inventoyr

Customer created a Credit Memo with an Inventory Return. They need to reverse this Credit Memo and associated inventory receipt. Is there a way to initiate the inventory issue with a Debit Memo, or does the inventory have to be handled with a manual adjustment? Thanks!Luke

5 months ago

Joeldk96Freshman I

asked in Distribution

Customer Pricing issue

We operate a wholesale business where all of our customers are assigned a discount level off of our list price. Some customers also have customer specific prices on a few items that we have negotiated. This was a simple structure to manage in quickbooks using pricing rules but seems to be very complex to set up in acumatica. Wondering if anyone else has come up with a good way to make this work in acumatica.Our challenges:Utilizing Sales price worksheets we can set up a worksheet for each discount level using customer price classes. We can also set up a customer specific worksheet for the special pricing some customers receive. Both of these function perfectly. Our problem is that we add items on a daily basis and using the above method we will have to manually create a new price worksheet for every new item we create. Utilizing Discount codes we can set up a discount code for each discount level and assign those to our customers however these discounts apply to everything includ

5 months ago

nperez94nawFreshman I

asked in Distribution

Tiered Vendor discounts

Is there a way in current functionality to set up tiered vendor discounts?I have this caseIf PO total amount is from 0 to 10,000 then apply a 15% discountif PO total amount is 100,000 then apply the 15% discount to the first 10,000 and apply 10% to the remaining 90,000 if PO total amount is 500,000 then apply the 15% discount to the first 10,000, then apply 10% to 90,000 and then apply 5% to the remaining 400,000 and so onThanks

4 months ago

acumaticapm182Jr Varsity II

asked in Distribution

How to insert a word "PESOS in the middle of number wording in Report Designer?

HI all, Can you help me about my problem here in Report Designer. I created a number wording for the printing of Checks, but my problem here is how do I insert the word of “PESOS” like this output: SEVEN THOUSAND THIRTY SIX PESOS AND 19/100This is my coding in report designer = IIF([APPayment.ExtRefNbr]<>[APPrintCheckDetailWithAdjdDoc.StubNbr],'* VOID *',PadRight(UCASE(replace(replace(' ' + [APPayment.AmountToWords], ' ', ' '), ' ', ' and XX/100')), 60, ' ')) If I insert the PESOS from this codePadRight(UCASE(replace(replace(' ' + [APPayment.AmountToWords], ' ', ' '), ' PESOS ', ' and XX/100')), 60, ' ') the word PESOS is not showing (no error encountered while saving this) Thanks

4 months ago

Page 11 / 42

Badge winners

kandybeatty49has earned the badge Field Service expert
Missy Mainhas earned the badge Configuration and installation expert
dgodsill97has earned the badge Innovator
Doug Johnsonhas earned the badge Innovator
sgaspar72has earned the badge Innovator

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