Distribution

 Hi, We have created a sales order with 20qty and in 1st shipment we shipped 8 out of 20. Once Sales order status was changed as “Confirmed”. Then i need to ship rest of the 12 qty. Then i reopen the sales order and try it. Create Shipment function is not working and showing following error.  Mention the Clear steps need to be followed for Sales order shipping.  

I have a GI that I am building that will allow me to show all sales orders our Powdercoating warehouse team need to work on.Many of our sales orders come with a lead time that is quite far in the future (eg, the material is not needed until the end of the month) but others need to be shipped urgently. We use the “Requested On Date” (renamed in my GI to “PC DUE DATE” to measure DIFOT, and I have added a “PC Scheduled Date” attribute that I have connected to the Sales Order UDF so that production planners can put a date that they want the team to prepare this order. I want to be able to have a combo box at the top of my GI that says “Painting Today” or something like this, but  cannot seem to make it work.  so for example, the production planner would select “Painting Today” (A) and if the Schedule Date (B) was in the same day as today, then only these records would show.   

We have a manufacuturing client that requires down payments and progress billing for large machines they manufacture.  Is there a good process for invoicing progress bills without project accounting?We are currently investigating adding non-stock progress bill lines on the sales order/invoice to accomplish this.

We recently upgraded a client and found that with the upgrade TR order types now require a ship via. It was never required it previously. As these are transfers between store locations these should not have ship via. How do we make it so that TR order types do not require a ship via? We can not assign a Ship Via to a warehouse or to the Order Type. The Will Call box does not suffice any longer.   

Hi, how many stock items can Acumatica hold?  I have a client that wants to load roughly 80,000 items with images.     Regards,Laura

Hi, We need to avoid the Bidding process when creating the Purchase Requisitions. That mean first start from Requisition form and finish without bidding process. Then need to create Purchase order from Requisition.  RegardsNethupul   

We would like to know if there is a method or screen to update a part numbers serial numbers currently stored in a bin location in a warehouse.

Are you able to track change orders to a purchase order with out the project module? Everything I’ve read regarding change order management all seems to require the project module.

Hi everyone, Is there a way of defaulting the non project code X on the bills and adjustment screen without a customization? Thanks, Patricia 

Hello Everyone,I was wondering if it is possible for an SO-Invoice to inherit the sales accounts from a non-stock item when the order type says use sales account from customer location. For instance , all the stock items would inherit gl accounts from the customer's sales account but the non-stock would inherit their gl accounts from the actual non-stock item itself.I haven't found any settings to play with on order types, ar prefs, or so prefs. I am thinking this is probably just locked from what you put in order types and that you would have to manually change the gl account. Thanks

For the life of me, I cannot figure out why a time entry is not updating the Balances or Cost Budget tab of a project.  I can see the transaction in Activity History.  I’m using the TMR03 project and Jane Doe and booking billable time to the 301 JRCONS project task.  I’ve tried with a time card and a time activity.  Both show in Activity History but neither show in the Cost Budget.  I’m using the November Sales Demo snapshot.

Hi, We need to insert Inventory stock item with few attribute values. We have tried to add attributes and only Item created process was success.Attached the Screen shots for further reference.  RegardsNethupul   

Hi All, We need to finalize the Inventory Open Balance Upload Template for upload all the Inventory on hand balances to system. Appreciate if any one have pre defined sheet that would be great help for us. We are in bit tight situation. RegardsNethupul 

Hello,      I think it is possible, I am just seeking whether there is existed solution, or how difficult if I have to do it on my own.      We plan to integrate 1 Acumatica tenant with another Acumatica tenant. For simplicity, they can exist in 1 Acumatica instance/url address for the time being. For the long run, they may sit in different Acumatica instances.      The need is below:Supposing we are having 1 Acumatica tenant A, as  Distribution center, all the inventory are stored there. But the inventory belonged to other owners. The distribution center only provide receiving, storage, delivery service. And we are having several sales channels in Acumatica as Tenant B or C. The sales channels will receive orders and payment from end customers.         When Acumatica tenant B receive order from customer, it sync the order to tenant A.        Tenant A do the shipping, and sync the shipment information to tenant B. (Maybe no inventory deduction in tenant B, causing the real goods are st

I am looking to make a report or inquiry that will work as follows:Select the customer Results should pull a list of all the parts that customer has order in s certain time frame. Time frame defined by input field. Is there something like this that already exists ? Any advice or help would be greatly appreciated. Thanks!  

Good day,Issue:  We need to transfer items, and quantities to multiple Amazon shipped to locations.  Transfers are done from our 3PL warehouse to Amazon but we can’t add a store information or ship to address  Any one have a solution to transfer the order based on the Amazon store information/location or havean export scenario that allows the transfer document items to identify the ShipTo locations on the Customer Profile?Thank youEvan

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));                    }