Distribution

Greetings,The new Dropship workflow for the Cancel Order Action in 2021 R1 breaks the link between the Sales Order and Purchase Order lines (previously found in [SOLineSplit.PONbr]). However, it is sometimes helpful in our business analysis to see the entirety of a canceled Dropship order.Any ideas on how to reestablish a link?  I’ve tried the new Workflow engine a little, but because the links occur at the line level, I haven’t had much luck.Thanks!

I'm having issues regarding with Invalid Column name '[POReceiptLine].[LotSerialNbr]' at Purchase Receipts - PO302000  , already tried to add the missing field to its database, but the error message still occurs.Am i missing something?

I'm having issues regarding with Invalid Column name '[POReceiptLine].[LotSerialNbr]' at Purchase Receipts - PO302000  , already tried to add the missing field to its database, but the error message still occurs.Am i missing something?

Hi everyone!We are looking for a few suggestions on the best hardware for barcoding with Acumatica WMS, Version 21R1.  Please share your favorites :)  Thank you!

Hi,I have read up on a few “cast” issues but can not resolve.  there are no customisations for this customer.  From the “Stock Items” screen, I click on an inventory id to view and receive the following error:-Error: An error occurred during processing of the field MRP Item: Specified cast is not valid..I have tried revisiting all configuration but no luck.Any assistance appreciated as to things to check.  I have looked in the Trace but not understanding it.Laura 

Is there a reports that tells, customer unpaid balance on each SO / Invoice.

We have a purchase order that has a prepayment applied to all the lines. There is now one line on the PO that has to be cancelled, but we cannot because of the prepayment that is applied. How can we cancel a PO line without cancelling the entire pre-payment and redoing it?

Could this be reconsidered https://community.acumatica.com/ideas/add-ability-to-restrict-users-by-sales-order-type-758It was said it be available, however what is available seems to be a workaround not so much of a solution.

Hi We have the USPS Stamps.com Carrier CS207700 plugin (PX.StampsCarrier.StampsCarrier) set up in Acumatica with our stamp.com account number and user information. Additionally, we have a customer set up using their stamps.com account number.  We are facing the issue that stamps.com is charging our account balance and not deducting or connecting with the customer account. We have the ship via set to the corresponding method on the Shipment document and have checked off the settings to Use Customer Account.  I have looked over the trace and profiler to see if anything suggests the customer account number or our account number being used. This information does not show.  Any support or direction will be helpful. Thanks, Schneur 

Is there a demo download for “Small Business Edition Distribution?”  If so, could you please provide the link? Thank you. John

Using Mac product, and Safari. In Quote or Sales Order. Enter partial item. Window opens as you move your cursor down, the scroll bar seem s to move by itself, making it hard to select the correct item.  This problem does not occur in Chrome on a Mac.  It does not occur on a PC using Chrome or Edge.   Besides trying using different browsers. We cleared cache, cookies and browsing history.  This did not correct the problem.  Any Mac users in 21R106 seeing this?  If so how did you resolve it?  Recently upgraded, didn’t see this in previous build 19R1.  I am going to create case with Acumatica but if you have a fix.  Please let me know.   Matt

I have created the filter but how to rename the filter?  

1.WE selling non stock item， I have confirmed that in non stock item [general setting], require shipping is blank2.When I create a SO to sell non stock item, the status becomes [Shipping ] and I can’t execute Prepare invoice. and can’t delete this sales order, What should I do?My current version is 20.210.0044Thanks!

We need some guidance.  Our bookkeeper has mistakenly book several AP transactions to the wrong financial accounting period.  How can we change the incorrect original booking to the correct financial period?  If we cannot change the accounting period for the original AP Transaction, how do fix this issue?  Reverse the original AP Transaction and book a new AP Transaction with the correct financial period in the AP module?

It appears that a non-stock item can be added to a purchase order, received and paid for without ever being added to a sales order and invoiced to the customer. Is there a way to ensure that that the customer gets invoiced (e.g. requiring a sales order before creating a PO)?

Received the following message: 'Conversion failed when converting date and/or time from character string'. My GI used two date fields; ARInvoice.DueDate and ARPayment.DocDate, I don't believe either of these data elements is stored as a Text string that would require conversion to be used in a GI. Is there more to this story?

Our client sells clothes that are tracked based on colors and sizes.He has created all possible sizes and colors as attributes. It would probably have been better to create different tables for different sizes for instance (it gathers sizes of clothsand shoes). For instance size :This leads to very large sets of possible crossings, while he will need only few of them : In the IN203000 screen, Matrix Items sreen, only the check one is created. That is perfect! :However, when in matrix view entry mode in SO301000, all possible crossings are made available.Ils it possible to display only the possible crossings instead of all (all the more as only those can be filled)  

I have a requirement to cancel the PO,  from a customization screenbased on the business logic. We have tried implementing the below code  but no luck. POOrderEntry docgraph = PXGraph.CreateInstance<POOrderEntry>(); docgraph.Document.Current = ItemList;  // Item List is current PO docgraph.Document.Update(docgraph.Document.Current);docgraph.Cancel.Press();Can some one help me on this?

Where do I find information in Acumatica I would need to calculate the average number of days a customer it takes to pay invoices.Another example would be a Customer’s average daily balance.These could be called Customer Performance Information, but others may have a different terminology.

The User need to create deferred revenue functionality in Receivable. Ex.   Sales order line Amount ---10000 (Configuration Changes) Once Shipping process and complete value should be transacted to Deferred Revenue Account. When complete the Configuration process in steps by step, user is creating invoices. Once created the invoice system should recognize the Exact Revenue. Therefore, we need to know what are the configuration steps.   RegardsNethupul

Does someone know what is the actual formula for import Vendor Attributes?I want to import lots of the data on Vendors - ATTRIBUTES -  Vendor Products highlighted as belowI have tried, but come out error Formula of import scenariosCR Error: One or more Attributes are not valid. 

We have to delivery inventory items to 2 different addresses for the same warehouse, one is a secure delivery, one it to a typical warehouse location.  We have only figured out how to set up 2 warehouses and then manually transfer the secured item to the typical warehouse.  Would there be a way to automate this transfer?  Or is it possible to have two addresses for the same warehouse?

Can someone guide us how to have a line item discount that shows on the customers invoice and, importantly, the discount books to the GL as a customer discount. Your help is greatly appreciated. 

We have dropship customers that require us to remove (overwrite with "X") the customer's contact (ARContact, SOContact) and address (ARAddress, SOAddress) information every few months. The address and contact are overdriven on sales orders and invoices. Acumatica's privacy tools seem to go too far, restricting the customer's account as well.Does anyone have a solution for this?

Hello,      I knew Acumatica has its scanner solution, and if the device is Android supported, we can install the APK package.       I am just wondering, is there any recommendation devices that is wearable and also can perfect working with Acumatica mobile application.      I see Zebra has its wearable solutions, just don’t know if it is compatible with Acumatica mobile application.   Anyone has experiences or recommendations?