Distribution

Hey Folks, wondering if anyone has had any challenges with some of the “TOTALS” metrics on the SO. We are looking to understand how the Unshipped Amount is calculated on a SO because it does not match the formula presented:The formula per the HELP icon is:The sum of unshipped amounts calculated for the lines with nonzero unshipped quantities of stock items. The unshipped amount for each line is calculated as the amount in the Ext. Price column (after Line-level discounts were applied) divided by the line quantity (the Qty. column) and multiplied by the unshipped quantity (the Open Qty. column). At the moment of order creation when no item quantities are shipped, the amount is equal to the Line Total; this total does not include any freight amount. This box appears only if the Inventory feature is enabled on the Enable/Disable Features form.Metrics:As you can see the Unshipped Amount = 7,336.54 If you review the lines for the particular SO in question we see:It seems like the Unshipped

Is Acumatica storing last Sales Order created date for a Customer?

Error: “The account is on a credit hold. Remove from credit hold?” When I am creating a new sales order, the following error has occurred. 

Hi Everyone Is there a way to see the document LINE attachments in the Vendor Details Screen (AP402000) without opening the actual document?  Thanks 

Hi,I have already imported the basic fixed asset information. We are doing a FA implementation and the system is in migration mode. However, I am trying to do a second import only to update the Last Depr Period and Accum. Depr (see below) and my import is failing. The second screenshot is my import scenario. I have also attached a copy of my data provider. What fields am I missing in my import scenario or Data Provider.  Thank you,Frances   

Hi, Upon adding the same location in warehouses, upon saving the added location does it disappear?We want to tag a different project task in one location to process a transaction with project ID tagging.Thanks!

Can AcuPayments be used with: WooCommerce, Big Commerce, and Shopify?If so, which behaviour should I be expecting? I’m assuming it’s #1.Authorize and Capture on the website Sales order and captured Payment transmitted to Acumatica Authorize on website – Capture in Acumatica before shipment. Sales order and Authorization payment transmitted to Acumatica. I’m also open to a link to documentation about AcuPayments, but my quick searching is not returning anythng menaingful regarding who it can be used with and how it will be used. Thanks!

There is no ‘ship date’ field in the Purchase Order.When submitting PO to vendor how do they know when the desired (RSD) requested ship date is? There is Promise date but that date is when we expect to receive the goods from the vendor and we don’t want to include that on the PO for fear of them using that as their ship date.Coming from SAP and Oracle worlds, I’m surprised there is no ship date on a PO and am curious what the community is doing over come this issue.  Look forward to feedback.  Thanks.

Is there a way to print labels containing the item # and description sorted by warehouse location? Storage summary seems like it would work but there’s no option to export to a label printer. Any tips would be appreciated.

In the Replenishment process, what does Replaned mean? How does Replaned affect the Create Purchase Order process?

We have Items without Replenishment settings but that are in an Item Class that has Replenishment settings.  When these items are on a Sales Order, we would like to capture them in the Replenishment process. We don’t like to use Mark for PO because then our Sales Reps need to know which items have Replenishment settings and which items need to be Marked for PO.Is there a way for the Replenishment process to catch items on Sales Orders that have no Replenishment settings? 

Hey Acumatica Community. Im hoping someone is able to point me in the right direction here and that its not something that needs an external plugin…..The scenario is i have a product that sells as each's but comes in a carton of 10. The carton has a different barcode to the product itself and i want to scan the carton barcode when paperless picking and for it to register as 10x units of the actual product. Can someone please explain what section of Acumatica i would go to set this up?Appreciate any help given. 

Does anyone know a way to add a box that is a stock item to a shipment without adding it to the sales order?  the Boxes tab looks like it does not have that option. Thanks.

Is it possible to configure an item on a blanket sales order?I have a customer who uses the Product Configurator to configure items on sales orders. They are exploring using blanket sales orders, but it doesn’t look like configuring is possible on a blanket SO type.

Would I be correct in thinking that the purchase order line item status completes when received and closes when their corresponding bill is paid?

We have a scenario on hand.   Assume that we have a Template Item SKU as Parent001 with three combination SKUs as follows: Child001Child002Child003Each of these products is being sold at a base price of $20Next let us say on the Sales Prices screen we have defined a quantity break of 5 and a price of $16.  On the Sales Order, if we add Child001 with the quantity as 10, then the price reflects as expected to show it as $16 each.   Our customer has a requirement that if someone buys 3 qty of Child001 and another 3 qty of Child002, thus exceeding the break qty of 5 defined at the Template parent level, the Sales Prices should kick in since the discounted break qty price is based defined at the parent level.   Any thoughts here to achieve without a customization?   Thanks in advance !!!     

The customer has created one GI that stopped displaying the data of adjustment Qty “tranPtdQtyAdjusted” after disabling this field Include in Qty Available in the warehouse screen. Does this field have any relation to Table "InItemSiteHist" of storing issue and Adjustment qty?

Hi everyone,I made a bulk import of Sales Order and realized that there are items that has been charged to incorrect warehouses. Those SO are already have a complete status.  What is the best way to correct this? Is it through receipt/issue or adjustment?

So it looks like move completed the WO, and then an employee closed the WO before the move was released. What should i do here… Error below: The WO WO128702 production order with the Closed status cannot be used in this process.  

Hi there,I have a scenario where I need to invoice one shipment on three different invoices, as our sales rep has agreed that the customer can pay over three months.Is this possible, rather than just creating one invoice and telling the customer to pay in equal instalments over three months

Is there a way to rotate an image in stock items screen also known as ID CST.IN.20.25PL?

I am trying to create a report for our purchasing team and they have requested that it show two fields from the Inventory Summary of the inventory item.  These fields are Purchase Order and In Transit columns.   It looks like this may be populated on the fly by the program and not actually stored in the DB, does anyone know if that is correct?  Is there a table that does store these numbers?

Hello Everyone,I am stuck again with the import scenario logic.  I have a Sales Order import scenario and I want to put the SO on hold at the end of the import.   The SO has multiple lines and I can’t seem to figure out where the ‘release from hold’ needs to go in order to allow the First Row of the SO to be added without hitting an error. I have tried to put it a few difference places.  I have attached the XML. In the current scenario the error is “the remove hold button is disabled” when trying to add the first row.  I have tried to put a hold on the SO and release it, or place the release in different places, and i’m not getting it to work. Any help is appreciated!

Hi,is it possible to take existing item codes and add attributes.  E.g. An existing Inventory item = W-01.  I want to use the Matrix Items to add combinations of this item.  So …. W-01-BLK-2.8;  W-01-RED-2.8 etc…Can I do this?   I have tried to add the Inventory item as an attribute but had no luck.  I don’t want to have to manually enter 200 templates with the Inventory ID. Any help appreciated.Cheers,Laura

I’m getting the following error when confirming a shipment.However, my items are packedWhile looking into this I found a wierd error on the details tab. It shows packed 2 while I only have one in the actual package and only one on the shipment.