Distribution

good day everyoneanyone can help me  what would be  the proper procedure in this scenario: i made a SO, then create shipment for it then invoiced it. the thing is i forgot in SO the column of shipping rule was tick as cancel remainder, it supposed to be back order allow, but i already made shipment and invoiced it already.the status of SO is ‘Completed’, the status of shipment is ‘Completed’ & the status of invoice is ‘Open’ we did not aply payment yet to this transaction because we made mistake from SO in column shipping rule and we are trying to find ways how to revert the transaction from invoice to shipment and the inventory to return to warehouse location and we can correct the SO to use it again.can anyone enlighten us abt this matterLooking forward for your helpThank you  

We have a client who is a “construction” company which also does manufacturing.  Since the materials they purchase ulitmately is applied to a project, they are required to pay sales taxes on their raw materials. Ideally, we’d like the PO and AP bill to calculate the sales taxes on the purchased goods (configured for Sales Tax Input), but would like the system to treat the sales tax as a landed cost to increase the value of the inventory.It seems like there are two mutually exclusive paths here:Configure the system to calculate the expected sales taxes on the PO and AP Bill by assigning tax categories to the stock items, tax zones to the vendor locations, and setting up the Sales Tax Rates with an input line. Do not configure the system to calculate the expected sales taxes, but rather enter the vendor’s taxes as a Landed Cost Accrual transaction to adjust the value of the received inventory, then add the LC accrual to the vendor’s invoice.  I suppose that if we’re using line-level tax

My company charges actual freight to our customers.  We collect payment for the product when the sales order is entered.  Freight is added before shipment is confirmed.  When the invoice is released a payment is created to cover freight.I get another process has updated the ‘ARRegister’ record.  Your changes will be lost error.  The following code does create the payment, but the payment staying in Pending Process status and the Invoice is not released.  I would like to be able to release the payment and the invoice.  Is there a way to do this?if (pay.PaymentMethodID == "TXCRCARD"){    if (doc.CuryUnpaidBalance > 0)    {        var invoice = Base.Document.Current;        var createPaymentDialog = Base.GetExtension<CreatePaymentExt>();        SOQuickPayment dialogInfo = new SOQuickPayment        {            CuryOrigDocAmt = balance,            PaymentMethodID = "TXCRCARD",            ExtRefNbr = Base.Document.Current.RefNbr,            Capture = true,            CashAccountID

Can you enter a blanket purchase order for services(consulting) with Acumatica warning when total invoices have reached the total on the blanket PO?

Hi everyone,We're currently using Pacejet integrated with Acumatica and have run into an issue with the shipping terms we've set up. We've configured our shipping terms to add a markup based on the shipment, which should reflect in the freight cost and invoice amount. However, after Pacejet completes the shipment and writes back the data to Acumatica, it seems to override both the freight cost and freight price that we initially set up.While I understand that markups can be configured directly in Pacejet, these appear to be solely based on the shipping cost, with no option to base them on the invoice amount.Has anyone encountered a similar issue or found a workaround for maintaining the shipping terms markup after Pacejet updates the shipment data? Any suggestions or ideas would be greatly appreciated!   Thanks in advance!

How do we Override email for Customer statements? When I select Recipients→ Override Recipients, the account default email still appeasrts in the Recipients section. In the image below, we only want the Statement to be sent to the Contact email and not the Billing email. The Billing email will not delete or allow us to overwrite it.   

Hello,  It’s worth asking rather than googling. Does Acumatica Mobile app exposes Shipment Screen ID SO302000 by default or is there a custom package which shows how to do it? We can add shipment screen in Mobile Application in Custom package, but doesn’t Acumatica have these already defined with the structure required for all users to view the shipment screen and to take action? We have several defaults provided but not few other important screens like Shipments, we do have WMS but that doesn’t list shipment screens either.Has anybody done the Shipment screen for view of shipment document, if you can share the container information of showing that wld be awesome. Thanks 

We want to make sure we are paying the right amount of money to our vendor . We do not want to overpay or underpay. I would like to know how to achieve three way matching in Acumatica.

Cannot get GS1 Barcode to apply "EA" UOM using the COUNT (30)  or VAR COUNT (37) AI.Any Suggestions greatly appreciated, I have no Issues using WEIGHT (3202)All other data parses accurately (01) GTIN (10) Lot (17) Exp Date when scanning 

Hi,There is a sales order which does not tally the line taxable totals and the summery taxable totals. It correctly shows in the taxes tab and the totals tab.  This is a one time issue which cannot be replicated. Do you have any ideas on possible reasons and a way to correct?Best Regards,Dulanjana

If yes , How and When ?If no , Why ?

I have a list of purchase receipts . I guess some of those purchase receipts are manually created in Acumatica in the Purchase Receipts screen. How to segregate the purchase receipts that was created manually from the list of all Purchase receipts.

We have a situation where purchase orders have to be generated based on sales orders, however the purchase order cannot be made until after the sales order has been invoiced.  Only after the invoice has been generated and sent to the client is the purchase order made.  This means that we need to sell the item before it is received.  However if you mark for PO a line in the sales order, you cannot invoice that sales order line until the purchase order has been received. I am wondering if anyone in the community has run into this before.   Any suggestions on how to generate purchase orders from invoiced sales orders without having to create the purchase orders manually.Thank you.

 Hi Team,We don’t want to scan the Original location. Directly scan the destination location, and then scan the item.  When we scan the Item, it should take the default location from the item as the Original location.We are trying to override the ScanMode related methods, which doesn’t help.Any inputs or references on this are much appreciated !!  Thanks & Regards,Vidyakeerthi K  

Can someone confirm if this is the correct QtyOnHand calculation? We encounter the following scenario frequently and it seems like a bug.When a shipment is invoiced and the invoice is created with the “Credit Hold” status because of the customer payment terms, the stock item from the shipment still shows On Hand at the origin warehouse of the shipment until the Invoice is Released.I’m not understanding it what scenario a company would want to report already shipped inventory as still at the origin warehouse, just because the invoice has the Credit Hold status. What am I missing here?

If I set moving average for Replenishment source : PurchaseWill the same moving average also be automatically considered for Replenishment Source : TransferIn the below , if moving average is set for warehouse 1 , will the same moving average apply to warehouse 2 , 3 and 60 ?  

Will someone tell me your best process for moving revenue from 1 project to another project?  We need to do this in a way that will have the Project WIP Billed to date report correct as well as the AIA reporting. Example:Project XYZ has revenue (billed to date) recorded to it from migration and should have gone to Project ABC Currently the AIA and Project WIP reports are reflecting that Project XYZ has the revenue (billed to date) We want the AIA and Project WIP reports to reflect the Project ABC has the revenue (billed to date) Thanks

Has anyone out there developed a functional supplier scorecard highlighting delivery, lead time, cost, etc.? We are only 6 months into our Acumatica journey, so have plenty to learn but thought I would reach out to get a little direction to start this project. 

Has anyone had experience with Fusion WMS?I am getting a login error upon sign in to the fusion app on our tc21 scanners that says “Error: The request is invalid” I can sign into the acumatica app with the same account no problem and The user has all the correct Fusion and Branch access roles. I just wanted to see if there is a step im missing or anyone has had experience with the mobile app. 

There are situations where we order materials without a formal PO and wait until we have the bill in hand.  Is there a way to Quick Process (in a similar manner as SO > Shipment > Invoice) a PO so that the Purchase Receipt is created/released and the bill is created in one step?

Unable to Map the Template Item to a child items even I selected the ‘ Allow Edit Template “ in item class and No open Orders as well. 

Does anyone know if there is a way to require Sales Allocations in order to create a shipment but prevent the auto allocation during order entry?I’ve tried utilizing the SO order type and enabling the “Require Stock Allocation” but that just makes it function like the SA order type which will allocate at entry time.This is causing issues where production could receive in production orders creating inventory on hand for an item. Then a new order is entered and consumes the new inventory before the allocation process allocates to a back ordered line.

Hello Everyone,We are working on a custom screen with 2 dropdowns, to load attributes as multi-select Combo.If we try to load all attributes, able to select save as expected. When we try to load the dropdown with some filter like load attributes based on Item class selection(Other field), dropdown values are loading as expected, however, while saving the record, selected values are getting cleared. Any input on this behavior is much appreciated.Thank you !! Best Regards,Vidyakeerthi K   

I have created several stock items using the create template item functionality.  I set the pending cost and pending cost date on the template.  The items are created with the pending cost and pending cost date, but they don’t show in the Update Standard Cost process list.  Items created normally are listed in the Update Standard Costs process window.

Vendors have some general purchasing requirements that are indicated in Attributes on the vendor profile:We need to display these values in the summary area on the Purchase Order form for comparison as POs are being finalized. We know doing so on the main summary area would require some customization, but we were trying to figure out if we could tie a UDF to that attribute based on the vendor indicated on the PO.Any thoughts would be appreciated. The hope is we are missing something simple...