Distribution

I created a drop-ship PO which has two SOs associated with it.PO has 7 items and SOs has 4&3.When I link either SO of 4 or 3 items, then go to the other remaining SO, the PO doesnt appear in the PO Link menu,it works fine when it not linked.Is this a limitation of drop ship functionality?

After avoiding eye contact with the matter for the last 19 months, we finally decided to start utilizing the UOM functionality in Acumatica. It has been about as easy as teaching a goldfish to speak Spanish.We chose the first item - a product which ships in Master Cases of (12) twelve displays. Each Display contains (20) Pieces.We have multiple companies set up in Acumatica. The main company is a wholesale operation, the others are a chain of retail stores.When the wholesale operation BUYS the product in question, we buy it in Master Cases. When the wholesale operation SELLS the product in question, we sell it in Displays. When the retail operations BUY the product in question, they buy it in Displays. When the retail operations SELL the product, they sell it in Piece.We have been able to get the Default Order UOM and Default Sales UOM set up, but we just discovered that when we place this item on a Sales Order and then create a corresponding Shipment/Pic

The system is throwing the below mentioned error while I am trying to generate Intercompany Sales Order. Here I have defined separate warehouses for both purchasing and selling companies.     Have even removed the default warehouse from the stock items.   And the below error for the Lot/Serial tracked stock items.   Kindly let me know if i am missing here something and how to resolve this error. Thank you.

When we try to confirm a shipment on the Shipments screen after a few seconds of processing we get an error saying this file already exists.  This is on a system we are preparing to go live with and have recently restored a snapshot (Settings and Business Accounts) which cleared out all the previous SOs and Shipments etc. I suspect a file is still present from testing previously but don’t know what file or where or even how to start to find out where or what it is. This seems to be only happening with Ship Via that are UPS based.Does anyone have any idea how to troubleshoot?Thanks,Trace:Phil

How to get Token expiry And renew the token 

Hi All,Currently multiple lines in shipment is created based on the allocation lines of the sales order line items if there are multiple lines for the same size.Is it possible to create lines only based on the sizes and not allocation lines? (club all allocation quantities and display based on the size) Will it be a customization?Really appreciate your responses on this.Thank you in advance.

I’d like to use the “Create Sales Order” action in an Import Scenario on drop-ship purchase orders. Here’s the process flow I’m trying to make work:Create drop-ship PO, enter PO line(s), save the PO Use Business Event to trigger an Import Scenario based on newly inserted record Import Scenario accesses the newly created PO record and does a “<Action: Remove Hold> (ReleaseFromHold)” step. This is working. Import Scenario performs “<Action: Create Sales Order> (CreateSalesOrder)” step, fills in Sales Order Type of “SO”, and selects OK to close dialog box, create the Sales Order, and enter the SO Type/number/line into the associated reference fields on the drop ship PO line. This is NOT working. ***I need help w this step.*** Import Scenario puts the PO back on hold using “<Action: Hold> (PutOnHold)”. This is working (when I inactivate the mapping lines related to #2 above). Import Scenario checks the

I am trying to figure out how to look at the landed costs for a stock item.We can see the Inventory value but we cannot see ‘how’ these values were determined.I’m looking for a query or report that would list an item’s cost history, it’s receipts, whether or not the cost came from the purchase, whether or not the cost came from a landed-cost entry, etc.  Can anyone point me in a direction or give the the DAC’s that might be involved in creating a Generic Inquiry so that we could get at that level of data?Thank you,Mike

Hi,  I’m trying to set up an approval map for orders based on the terms in the financial section of the SO. See attached image. However the orders don’t go into approval mode. It goes straight to open.   

Does anyone have any idea whether Acumatica stores the default price associated with an item and its changes over time or what the default price was on a given day? such as Item 123 was $18.75 on April 15 was changed$ 20.00 on October 2 and changed to $ 22.50 on October 15.  We are trying to compare our default prices versus our unit prices  in our sales orders over a given period of time.  I have a reasonable plan or solution on how to handle moving forward but I am wondering if I could use the line level fields (Manualprice = 0 and discpct = 0) or something similiar to identify where unit price = defaultprice on old sales orders?Any ideas and thoughts are welcome

We recently walked through the steps to enable the new WMS engine in 21 R2 and also enabled paperless picking. We are now experiencing multiple issues across the different WMS functions when trying to scan/input manually where it is telling us the item is not available/item is not where we are saying it is/etc even though we can see on other inventory inquiries the item is where we are saying it is. We have experienced this error during paperless pick, scan and count and pick, pack, ship for a transfer. Anyone else run into issues once enabling the new wms engine? Do I need to revert back to the legacy engine?

The process was working OK and no recent changes have been made to the configuration, nor to any customization. Normally there is around 150 to 200 skus that come up to be processed.Trace window:Error: An error occurred during processing of the field Transfer ERQ: Thread was being aborted..System.Threading.ThreadAbortException: Thread was being aborted. Any ideas?Thanks  

When creating multiple AP Bill for a single Service PO, the quantity for the second AP Bill appears as 0.00 by default. I have done the following setups but am wondering if I missed anything, as logically, if the PO is still open (and set PO Line to close by Amount) then irrespective to the number of AP Bills the quantity should repeat at 1 (unless Acumatica defaults is 0.00 - can this be changed).Below is the scenario, using Acumatica demo data.Non-stock Item setup: Close PO Line: By AmountPO created for 1 unit at unit cost of USD20001st partial AP Bill created for USD 800.00. Quantity 1 automatically appears when creating AP Bill and ADD PO or convert PO to AP Bill and up

All our numbered transactions (for instance invoices, sales orders, shipments etc) need to have the restriction that the master document can’t be deleted.  For this reason, I have set up all the users with “insert” access to those types of screens.  In most cases this works fine, but occasionally I’m finding that a button on the screen doesn’t work when “insert access” is used.  This is one example.  The “add order” button is disabled for this user.   Am I understanding correctly that it should be working in this circumstance?

Currently the ITEM AVAILABILITY button in the Sales Order Screen which opens a new tab to the Allocation Details for the highlighted line item.How can we make this a POP-UP screen rather than opening a new tab each time?Thanks for any help.John

I have a modified Shipment Confirmation report SO642000 that is printing a extra blank page.I am unable to find the causeCould someone take a quick look ?

We have several different warehouses that we stock our component parts depending on which building they are consumed at.  I am trying to set a different ROP for each warehouse.  When I go into stock items and add the other warehouse, I am getting the following message: Error: Another process had added the “INItemRep” record.  Your changes will be lost. In Acumatica can you have different ROP’s for multiple warehouses?   

Hello all,I want to load inventory opening balances on the receipt screen with series.Does anyone have a template to load this information?.Best regardsJennifer

Hi Everyone,I am experiencing issue regarding on no batch entry on posting of inventory transaction.Please see attached photo for your ref.It seems that the posting set up is periodic. May we know where is the field that I need to trigger to become a perpetual posting? Thanks !

We use Landed Cost.  We need to allocate freight charges over several purchase receipts.  Our suppliers will aggregate freight charges from several shipments and add the freight charge to just one invoice.  If we use landed cost and add the aggregated freight charges to the one purchase receipt, the cost of the items on that one purchase receipt are inaccurate and distorted.  Is there a way in the landed cost system to add a freight charge to a few fully received purchase receipts to better spread the aggregated freight charges? 

Our client has requested to issue them multiple invoices in one sales order based on the payment method they have provided.Scenario:ABC Company ordered to XYZ Company 10 pcs of keycards, 100pcs of lockset, and 6000 pcs of Dustbox for ANSI Strike. Payment Terms as follows:For 50% downpayment - No shipment of stock items but with issuance of Invoice for downpayment If 80% of payment were collected - Sales Team will start to prepare to ship out the items that will create shipment on the system, update inventory issuance and issue new invoice for all items less the 50% downpayment For remaining 20% collectible - This will be reserved for retention - No shipment but with new invoice tagging the Sales Order reference.Is this possible in Acumatica? Any tips and advise for this kind of transaction?  

When I see the Stock Item screen my items get duplicate.  

Version 22 R1I have added custom fields to accept shipment location and ship via in the sales order and split shipment is created based on location and ship via for the selected warehouse.I have override the ARInvoiceEntryExternalTax && SOOrderEntryExternalTax GetToAddress with line parameter to get the Location address selected in the line. These changes are working fine in 20 R2 and calculate the tax based on the location selected in line, but in 22 R1 it calculates tax and failed to calculate tax in the Sales invoice and throws an error: TX Error: Failed to get taxes from the external tax provider. 

 Hello,I’m getting some issues with Creating template items: The item with the same inventory ID already exists. Change segment settings of the inventory ID. Could someone enlighten me on a method to make this work?

Hi,I would like to know if there is a possibility of not impacting the stock of an article stored according to the SiteID ? ThanksXav