Distribution

We are running 2019R2.I can successfully release a worksheet of sales prices that are setup as customer specific pricing with an alternate ID specified:But when I lookup the pricing on Sales Prices screen, it does not show the Alternate ID:On the Stock Items screen, under Cross Reference tab, it does not show as Customer pricing, but as Global (without the customer number):Oddly enough, when processing sales orders, the alternate ID can be used for any customer and it will find the corresponding stock item number (not what we wanted).  BUT it will only assign the price for the customer that was specified when the price was loaded via the worksheet.  So the pricing aspect of this is still working. So my questions are:Why doesn’t Sales Price screen show the alternate IDs?  How do I fix this? What is causing the Stock Items screen-Cross Reference tab to tag this as Global instead of customer specific pricing?  How do I fix this?Thanks.

Acumatica Distribution Edition WebinarMarch 17, 2021 11:00 am - 11:30 am PSTJoin us for a 30-minute webinar where you will hear an overview of Acumatica Distribution Edition and discover real-time visibility into sales, order management, inventory, purchasing, production and services—and accounting information. In addition, discover new Acumatica 2021 R1 features.REGISTER NOWDistribution Webinar March 17, 2021 

Hi Everyone!Does anyone know of a way to assign sales reps in Acumatica based on item class and customer/business account at the time of sales order entry?Example: IF item class = Consignment, THEN Sales Rep = Business Account OwnerAny help would be greatly appreciated :)Thank you! 

Is there a way to generate requisitions from Prepare Replenishments screen?There is need to utilise Bidding process on requisition for items that are below reorder level, currently it goes straight to Purchase Order.

Hi!Let’s picture a scenario where a Retail Company sells shoes through 45 stores and They have the next environment in each store:POS software with an interface to Dynamics GP POS software update GP in real time, it means, when a sell is being made in a store, the POS use the GL accounts defined on the item to post in GP the invoice process (inventory, ar invoice accounts) and in the same transaction, the payment is registered too (Post in GP the Payment accounts such as sales account, bank account, etc).With that said, let’s say that in december they process 200k transactions. The 200k transactions are related to the POS process described above.My question is, 200k transactions are considered ERP transactions instead or Commercial Transactions?Thanks!

For example, warn the users that there are open purchase orders when you change the status to No Purchases.  Procedurely, users should use the Inventory Summary or Allocation Details before changing the status but a warning would be a good idea.

Hi everyone,I have a very old order. It’s shipped and invoiced.  But all items in this order still hold in inventory allocation.  Does anyone knows how to release those inventory? thank you.  

Using 2020 R2 and we don’t have the data collection feature.  We’d like to add the Inventory Transfers screen to the mobile app.  I want to make sure I’m not missing anything - do I have to create a customization to present that screen on the app?

I am seeking any feedback from those who have successfully or unsuccessfully used the ShipEngine shipping solution for Acumatica.We have tried the ShipStation integration and found its functionality limited (especially with international orders) and found their support lacking.We are now considering the ShipEngine solution.If you have used it, I am very interested in hearing how it is working for you and how it compares to other shipping solutions you have tried.

Hello, currently when we create a return to a vendor it will reopen the PO,  is there a way to create a Business event that when a return is released it should complete the PO?

I cannot figure out why the Inventory ID field in the mobile app is showing as the Inventory ID description, but on the GI it shows correctly. Anyone have any ideas? 

Hi Folks!  We have a client who would like to simplify the creation of new Stock Items in a Multi-warehouse environment.  Other than using GI’s as a data provider and running imports, does anyone have any tools/utilities to automatically establish item warehouse details using some default settings for newly created stock items?  I’ve not gotten into the workflow designer as of yet to see if there’s anything there that could assist, but if you all have some tips or tools to assist, please reply.  

Hello,        After upgrading to 2020R2, build 203, we are suffering shipment status issue now and then.like below:         Poorly, today we encounter another status issue on Sales order screen.1 Sales order says “shipping” status but no related shipment can be found.          Why and how did this issue happen is unknown. Maybe it is a rare case. However, anytime, if this kind of issue happens, what can the user do ?         The user has to wait the techical staff to fix in Database.         In Acumatica we are already having “balance validation” and “inventory validation” functions. So can we also have a “status validation” function, then system can in some way correct some incorrect status documents.

Do we store the return label tracking number in Acumatica?

Hello Everyone,In the Sales Order screen, by default can we load the “Financial Settings” Tab instead of loading the “Document Details” Tab.Is this feasible? if yes can you please provide the solution?Thanks,Naveen B

Hello, I believe I know the answer to this question but I wanted to confirm as I am still just learning the system. Is there a way to create a mass 1 step transfer for multiple items on different dates? All of these will be going from and to the same locations so only the dates for the transfer would be different. Seeing as the date is in the document header for a 1 step transfer I am thinking I cannot do an upload with all of the transfers on separate dates but I wanted to confirm.  Thanks,

Hi guys,I want to tracking serial number for some high value item. I enabled Lot and Serial Tracking feature. I created a Serial class and used on an item. Than I tried to follow below manual to test it but there is no separate line let me scan serial number. Does any know what’s going on with this?https://help-2020r2.acumatica.com/(W(5))/Help?ScreenId=ShowWiki&pageid=8a849d2b-0a55-467f-b537-28bc6e192de3

I was wondering how well our Acumatica distribution takes care of planning purchase orders and inventory projection (calculation). Attached is a possible scenario in Excel format.. I have also submitted this to AUGForums.com  (https://www.augforums.com/forums/acumatica-distribution-modules/replenishment-demand-calculation-and-order-types/#post-6068 )., I didn't check D250 but I did search the help.acumatica.com and didn't find any answer. The projection of SOs, shipments, POs, receipts and inventory level for a particular item in to the next 4 weeks is a basic necessity for warehouse people. purchasing people and manufacturing people. It should be available in the inventory module and the MRP module. When inventory falls below the ROP for instance in week 2, a red flag should be raised. A bar chart would be nice.  Thanks for your help. Toon Six (ToonSix@intercs.com) .

Hi!I run a report for our sales team every week that includes the following: The problem with this report is that the column “OrderStatus” gives me that status of the sales order, when i really need the status of the sales order line.  Ex: The sales order has 5 lines on it, 4 of the 5 lines are shipping but the one that is not shipping shows up on the report with a status of “shipping” because the status of the sales order is shipping but the line is not.  Is there anyway to get a line status put in there?

Is there a way to recalculate the margin of a stock item sold, to take into account a cost adjustment recorded after the sale, but which relates to a receipt prior to the sale ?Example :02/01/2021: purchase receipt of the article with a cost of 100 USD02/01/2021: billing of the purchase receipt with the same cost02/02/2021 : sale of the stock item for a price of 130 USD => margin equal to 30 USD02/03/2021 : landed cost of 10 USD related to the purchase receiptI would like the margin of my sale to be recalculated to 20 USD. Is it possible ?

Hi there -  We have a customer who uses the ShipEngine plug-in to perform international shipments. In cases where there are multiple boxes being sent within a single shipment, this causes an issue.A separate label for each package is created, which is proper - every box needs it's own identifier for tracking.  BUT, Acumatica treats each package as a separate order/shipment. The order can not be broken into multiple orders for customs purposes.  This could be construed as an attempt to skirt customs fees. Most packages with values under $2,500 don't need the extra paperwork as they fall below a threshold.  So, an order for $7,497 that gets put into three boxes would need the paperwork as it's above that threshold.  BUT, if the system treats each of those boxes as a separate shipment, and values them each at less than $2,500, it could be seen as a means of trying to hide value and avoid fees.  How do other folks handle this in the system? Any thoughts?

Hello Guys;  Hope you’re doing Well  I have a problem when releasing one invoice:I get the error message “another process has added to InRegsiter”I’ve cheked the Issues List and there is nothing with the the shipping Number of the Invoice  Any ideas ?  Thank you :) 

Hi Everyone,   We just upgraded our Acumatica from 2019r1 to 2020r2 this week. I find a new thing when I add  items to order. A dropdown input always follows the last item. Does anyone know what it is used for?    

Hello,             Is there a way to set an invoice minimum amount as $200?Note:   If the amount is below $200, the system don’t forbid this invoice, the system will just automatically add the total up to $200.            Currently, the user can manually add a non-stock line at the invoice to make the total no less than $200.        Is there a way to make it in automation?  I am thinking of the Freight calculation.

In some cases, components within a kit can dropship directly from a vendor to a customer. How can I manage this in Acumatica without removing the component from the kit?