Distribution

Hi,We have vendors which are are issuing price lists based on a quantity 100 or 1000.Base, sales and purchase UOM is MTR.For example: The vendor price is $ 30.65 for 1000 MTRThe purchase order is for 1250 MTR with no specific packing sizeIf you divide $ 30.65 by 1000 you get a MTR price of $ 0.03065 per MTR which gives you 5 digits after the comma. Since the unit price has only 4 digits after the comma you can  only enter $ 0.0306 or $ 0.0307.It would ideal to have a vendor price worksheet were you could specify prices per 100 or per 1000. Would be interesting to hear if anybody has a solution for this problem.   

We currently have a problem whereby we are unable to correct a 2-step transfer (Transfer Order).Suppose we have 10 x ABC Item, which has been captured onto a Sales Order of type Transfer. It is then picked, packed & shipped, and the Release IN action on the shipment has been clicked.On the receiving warehouse, if there was any miss-picks, e.g. qty short picked by mistake, it seems that there is no way to ‘correct’ the in transit qty (i.e. there would be a qty that remains in transit).Is there another way to correct cases like these, without receipting the short delivered qty into the receipting warehouse, and then transferring this short delivered qty back to the originating warehouse?I’m hoping there’s another solution.Thanks in advance for any assistance.

Could you please precise following statement: https://help-2021r1.acumatica.com/(W(27))/Help?ScreenId=ShowWiki&pageid=3fb8f768-a8ea-44a8-9a4f-8b78ecb947e8 The issue is to understand clearly when the financial badge of  landed Costs are being posted to the inventory and in which case it should be posted to the Variance account.Note: Evaluation method is : averageAs far as I understood is, that the inventory on Hand should be 0 (Goods are sold out) so that the posting will be done to the Variance account.Unfortunately I have several cases where the postings are still going to the Variance account although inventory of the received item is still available (in the concerned warehouse).Does anybody know if there are other reasons for this behavior. The goal is to have the posting to the inventory (and Accrual account) as there is quantity available

After we upgraded from 2019 R2--->2021 R1 we have this error: “Error converting data type varchar to numeric.” pop every time we try to load a GI that is supposed to display sales orders that have a UDF checkbox checked. Anyone have any ideas?  Attached is a screenshot of the trace.   

 Invoice without discountStarted a return and the discount automatically apply to the document  Hi everyone,I met a very weird problem. The case is I created a SO for a customer(There is no discount applied at this moment) and invoiced. Later I apply a negative discount for the surcharge for this customer.  Than I started a return for this SO. The negative discount was applied to the document automatically. If I didn’t check the amount, I will refund more money to the customer.  I don’t know if this is normal or a bug? With my understanding, the return should be base on the amount on the invoice. It can not apply any discounts.  Does anyone know this ? or how to set do not apply discount for the return.  

HelloI was wondering does anybody use Shipment Confirmation form as Delivery Note and Cargo Shipping Order? If so, how is it set up? (Just for reference we are not using any Integrated Carries options).Normally those 2 documents are generated separately but in Acumatica I cannot see any other documents related to Shipment as Shipment Confirmation.Thank you in advance for any tips.

Subitems appear to be inactive by default. Is there a way to mass enable inventory subitems all at once? I get this error when trying to use the inactive subitems in a Sales Order:“the default value of the subitem segment is inactive”

Hello Everyone,I have extended Sales Order graph and override SOOrder_RowSelected even like below but it is not executing. Can someone help with the root cause or suggest a fix for this please.Sample Event Code: protected virtual void SOOrder_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected baseHandler)           {            baseHandler?.Invoke(cache, e);            SOOrder row = e.Row as SOOrder;            if (row == null) return;                       if (!string.IsNullOrEmpty(row.ShipTermsID) &&                          (row.CuryLineTotal + row.CuryMiscTot + row.CuryTaxTotal) <= 49 && row.Status != SOOrderStatus.Completed && row.Status != SOOrderStatus.Invoiced)                cache.RaiseExceptionHandling<SOOrder.curyOrderTotal>(row, row.CuryOrderTotal, new PXSetPropertyException(“Order Total is less then $49. Please review”, PXErrorLevel.Warning));                    }

Hi,a client of mine uses the Sales Price Worksheet to group inventory for Customer Price discounts.  Where do I set up the Price Workgroups to then allocate against each item?  I’ve looked everywhere. Regards,Laura

Hi,  I’m trying to creating Inventory Class to my stock and not stock items with an import scenario using the Stock Item and non stock item screen.Has anyone successfully completed import scenario sheet regarding the Item class? RegardsNethupul

Hi AllCurrently, we have auto trigger customer statement to customer every month.For those over due customer , we would like to send reminder and would like to use “dunning letter send by email” May i know how to set for it?We have “tick” the “ SEND DUNNING LETTER BY EMAIL” what is the next step?Does it mean system will auto trigger to customer once the invoice is over due?  

Hello,     In 2020r2, we’ve had a new feature called “intercompany sales”.https://help-2020r2.acumatica.com/Wiki/(W(2))/ShowWiki.aspx?pageid=e4827607-362f-40fb-b466-303c414ee980     According to the guide, it says it can deal with “sold goods” scenario. Unfortunately, according to my understanding, it is not.       Both AR invoice and AP bill has nothing to do with Inventory.     For real intercompany goods sold, the inventory of company A which pretends to be the vendor should have qty deduction, while the company B which to be the customer should have qty increasing. And in most cases, we do real shipment. We ship goods from company A to company B. Company A do real shipment, company B do real receiving. The new feature did not take this into consideration.      So in short, can we request for a full feature of “intercompany sales”, which we can extend the PO to a SO?

Many times customers need to transfer from One Warehouse to another; however there is a time delay between the transfer.  The 2 Step transfer will allow for a 2 step process; however the only visibility is in the “In Transit” columns.  This data is usually challenging to see on majority of Screens and Reports.  If the 2 step transfer allowed for a Via Warehouse, then the users can quickly use the standard screens to see the location of the inventory.

Does anyone know if there is a way to indicate any changes to a Purchase order or Sales order after the change has been made?  Maybe a way to Highlight what changed or have a PO Version # at the top? Thank you. 

Hi, Recently we had RC for a customer who returned items during the transaction we were not yet on Acumatica. We had to process the RC with special inventory code where price and discount was in accordance to the original invoice. Now during shipment and CM preparation, the system automatically updated the SO’s discounting to that of current discount of the customer. Unfortunately, the clerk failed to check that prior posting resulting to discrepancy. Is there any way or work around that we can avoid the same system behavior in the future? TIA! :)

I reduced the Quantities On Hand for all Stock Items to -0-.To effect a change in Valuation Method, can this be accomplished by changing the associated Item Class records? As I adjust the quantities and costs back in, will the Item Class record make the change to each Item record?Or do I need to make the change to each Inventory item record to make the valuation change take effect?

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