Distribution

One of my clients sells magazines. Historically their item MAGAZINESKU was purchased as a finished good from a single vendor who produced the entire item. Now, however, the magazine is being produced by two vendors. One produces the covers (COVERSKU) and the other produces the inside pages (INSIDESKU). These are still sold as the MAGAZINESKU item. What is the best way to go about purchasing COVERSKU and INSIDESKU then assembling them to create the finished good of MAGAZINESKU in inventory?If I was starting from a blank slate, this seems like a clear Stock Kit with Kit Assembly. However, MAGAZINESKU already exists as a Finished Good and it is NOT already setup as a KIT. I do not believe I can simply convert it to a kit. Acumatica Cloud ERP 2022 R1Build 22.114.0029 Distribution EditionThanks, David

Is there any way to Auto allocate/reserve quantity for sales orders in line details?

I’m sending a Sales Order with Pre-Authorized Payment thru REST API in Acumatica. This works perfect in my local Acumatica instance. However, I can’t get it worked when switching to Acumatica.com and I’m getting this error “The order cannot be applied, the specified combination of the order type and order number cannot be found in the system.”. It works well when I remove the payment details. { "BillToAddress": { "AddressLine1": { "value": "3153 Doctors Drive" }, "AddressLine2": { "value": "" }, "City": { "value": "Los Angeles" }, "Country": { "value": "US" }, "PostalCode": { "value": "90017" }, "State": { "value": "CA" }, "custom": {} }, "BillToAddressOverride": { "value": false }, "BillToContact": { "Attention": { "value": "Mr." }, "BusinessName": { "value": "Gregory Luton" }, "Email": { "value": "gluton@hotmeal.com" }, "Phone1": { "value": "(310) 341-3975" }, "

Does anyone have a solution for customer loyalty/rewards in Acumatica? I know it is not out of the box functionality. What are some options you have found?

I was able to set up 7 email accounts successfully.. but have 4 more to do and this is the error i keep getting: The mail send has failed.535 5.7.3 Authentication unsuccessful [BL0PR0102CA0020.prod.exchangelabs.com]I use the same exact settings as the ones that did work but it still fails. HELP! I am so lost as to why this wont work.  

Version-21.217.0035Hi,am trying to make vendor field always enablei tried by adding workflow to the package and also programmatically written row selected event to make enable 

hi expert.I have problem in below image. I custom warning if value field Weight and Volume negative, when I type 0.000000 → show warning → recent value field Weight in screen = 0.00100 (old value). I dont want refresh value this field. ( recent value field Weight in screen = 0.000000).Can you help me?Thank you so much. 

We are having a workflow issue we need help with.  Our warehouses are in Alaska.  Our inventory vendors are in the lower 48 states and send inventory invoices weeks before we receive the inventory in Alaska.  For planning purposes, we want to get these invoices into our Acumatica system before the inventory arrives.  How can we achieve this goal?  What workflow can we adopt?   Now we are reverting back to Excel spreadsheets and other pre-ERP solutions. Your help is greatly appreciated. 

Anyone know how Easypost would work if I’m only shipping Collect using my customer’s account information.  We have a client that has 250 clients and 90% of the orders shipped use UPS Collect and utilize their CUSTOMER’S UPS account number.  Can I setup them in Easypost easily?  We haven’t done that before.  Anyone has any best insights that would be awesome. 

Hi All, Is there a way to update the Reason Code ID? I don’t see anything that would indicate that this is possible. 

Has anyone had any luck in customising Shipment fields to allow editing after shipment confirmation?Our company requires multiple shipments (one for each vehicle) against the same order. Due to Acumatica limitations, this means we need to confirm the earlier shipment to open a subsequent one, despite the shipment not actually being confirmed. Naturally, this leads to errors, which are particularly difficult to correct due to too many subsequent shipments having been ‘confirmed’ already.This leads to the issue of how to rectify errors. Should there be any way to customise the editing of Shipment fields (such as date, description, UDFs, and quantity) even in a Confirmed state, it would help a lot to resolve our problem.Thanks!

Two stock items have the incorrect inventory ID. TT1000BLK and TT1000GRY should be TT1000DBLK and TT1000DGRY respectively. Production orders have already been created using these incorrect IDs.I know I can create an entirely new item with the correct ID and change the formula. However, is there a better way to do it so the accounts that have a production order already created will not be affected?

Encountered an error while releasing the issue and adjustment as follows - Another process has updated the 'INReceiptStatus' record. Your changes will be lost.  

Hello,      We would like to charge every cusomter a same fee by using some (Means might not be only 1 line, might be several lines) Non-Stock items on SO/Invoice.Everytime the sales person have to manually input the lines on SO or on Invoice.      Is it possible to set default items, when typing SO or invoice, the default lines automatically filled in.

HI. I am looking for a report that shows the same information as the standard Inventory Valuation report that shows inventory as at a certain date. For example, I want to print the report showing what the inventory was as at Dec 31,2022. I’m actually surprised that Accumatica doesn’t have this as a standard report. Thanks

Does anyone know how Acumatica distributes shipping charges on a single shipment that contains multiple sales orders? 

Is there a way to stop freight lines from being taxed on invoices.  We have implemented avalara avatax.  

We have implemented the Shipping Integration module with Acumatica and we want to turn off the automatic freight charge on sales order invoices.  Is there a global setting to turn this off?

Acumatica will only allow items from the same warehouse on a shipment.I’m trying to understand the logic for why this would be limited.I have customers with multiple warehouses in the same building and items on a sales order could come from any of those warehouses. They would like to be able to have all the items on one shipment record.Can anyone help me out?Thanks!

How can I see non-replenishment items on sales orders that I need to order?  Here is my issue.  We often have a salesperson put an item on a sales order, and we  have zero of that item in stock (and zero on order).  The item does not have a replenishment set for it.  AND the sales person does not mark the item for “Purchase Order”.  How can I prepare a Puchase Order and have this item show up on the Purchase Order?  Or how can I “see” this item so i know to put it on a purchase order?  Thank you in advance for any help you can give to me. 

Hi,I would like to set up the replenishment setting by using forecast model moving averageHowever, it seem like nothing much info i can get from online Can anyone share the setting step? Thanks,Cheng

Can “Automatically Apply Amount Paid” be turned off on the Load Options screen when loading documents to apply a check to in Payments and Applications?  

I need to report some data to a supplier via ASCII files. those files have header record, details and end record. How can I achieve this with Data Providers. I tried to load the fields from the file but it only reads the first record which have a different layout than the details record and the end record. Maybe it is better to do this with the Report Designer?Please advise. Jesus. 

Can an item on a Sales Order that does not have Replenishment parameters be added to a PO in the Create Purchase Order process without item being Mark for PO?

Hi,  A total of 8000 stock items need to be inactivated via the import scenario.  RegardsNethupul