Distribution

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

I have marked Inventory / Inquiries / Inventory Summary for inclusion in my favorites, but on my favorites page I would like it to say Item Allocation instead of Inventory Summary.  I don’t want it to change for the other users.It seems like a good solution would be to copy this to a new GI with a new name, but I don’t know how to do that.  I have admin rights.  I see screen ID CST.IN.40.10.00 but I don’t see a way to edit or copy that.  I can’t find this screen under Generic Inquiries.  I’ve read here that it needs to be done with a Customization but is there a simple way to do that?Thanks.

We are using Item Replenishment now.  And it works great.  We want to add Item CLASS replenishment.  We need help with understanding how Item CLASS replenishment works.  For example,(1)  in the Item CLASS settings tab, we do not see any MIN / MAX settings.  Where are these MIN / MAX setting set? (2) how does Acumatica know which item in the Item CLASS to reorder?  Does the system look to the ITEM replenishment to get the MIN / MAX amount to create the Item CLASS replenishment?  Thank you fo your help. 

Hi Team,We have a requirement (Build 22.106.0015) where we want to change To Mail address for Email Invoice/Send Invoice actions to a generic email address, more specifically the To Mail address should use Customer Parent Account mail ID if configured but if not configured then should use the Customer mail ID. And this functionality we wanted to have for Invoices, Invoices and Memos and Process Invoices and Memos screens. Can you please let us know the best possible way to achieve this.Thank you!

Hi All, We are experiencing some odd behavior and before opening a Support case, I wanted to see if anyone has experienced something similar.A few items are blanking out the whole Kit Assembly Transaction once added.The items are active, are marked as a Kit and have an active Kit Specification Record.Blanked outExample below with another item that works:Any thoughts on why a few items would error out like that?

Hello  I'm attempting to create a single import scenario on InventoryItem attributes to update any item attributes without overriding the existing data.  When running an import scenario with item InventoryItem attributes, if a field is empty on the import source sheet, then on import, it will override the data in the destination in that field and make it blank.  I tested in the mapping sections using ISNULL([WILDLIFE],[Answers.Value]) in the Source field/Value, and had success. The issue I face is attributes that are checkboxes. The date gets imported as "False". I tried various IIF statements, with and without converting the data to different data types, and still no success. 

I came in today and the add new record “+” is missing from requisitions.  I am in the admin group and this group has delete rights on the requisition screen.  We have not made any modifications over the weekend.  Where else can I look??We are on 2022R1 , 22.110.0018 Thanks…Matthew

Is there a way to add a shipping fee per item? So any time a particular item is added to a sales order, a shipping fee will be added based on that item.Ideally it would be a setting tied to weight - Any item above a certain weight will get a shipping fee added to the order automatically.Currently it seems only possible to add a fee per amount or weight of the entire shipment, rather than item specific.

Hi EveryoneI am trying to review the audit history of Item sales categories getting the below error in Navite Acumatica instance. Audit history enabled for this screen.As a workaround I am reviewing the audit data in Audit history Page and also through generic Inquiries. But I would like to understand the reason for Error.  Please provide your Inputs. Thanks Manikanta

When I create a Business Event to trigger off of a new GI, the Values in the Trigger Conditions display incorrectly (do not display as it is shown in the GI). The B/E do work correctly, it is just hard to manage this.Below I am restricting the BE condition to warehouse ID is less than ‘50’ (and customer id is not correct either). But as you can see the Warehouse ID displays ‘less than 411’ (same with the customer id - displays an incorrect value).I understand it must be using an internal ACM id or something, but how can I get it to display as the actual field in the GI displays? I am not sure what i am doing wrong here.Business Event conditions GI displays the Customer ID and Warehouse ID correctlyAny help or idea would be greatly appreciated.

Our client sells smartphones and they want to track the serial number and the IMEI code of each handset.We could achieve this by having one serial number that encompasses both the serial number and IMEI code but it would be messy for doing lookups.Are there any other ideas or customisations that can do this? Thanks James 

I could’ve sworn that when an SO Line gets created for a new combination of stock item + Warehouse, it automatically adds this to the Item Warehouse Detail table. Maybe I was dreaming though, or mixing that up with InSiteStatus. Now we’re discovering a bunch of Sales Order Lines w/ no “cost” because an Item Warehouse Detail row doesn’t exist for that Warehouse (even though a Current Cost exists on the Stock Item profile). Similar to the “Recalculate Prices” action on the Sales Order screen, is there (or could there easily be) a “Recalculate Costs” action? I’d like to avoid deleting a line and recreating it just to get the cost to retroactively fill in.Have any other customers, who deal with multiple warehouses, found a good solution to this problem? I guess I assumed that Acumatica was doing more intelligent automations on the back-end to ensure standard cost data integrity, but I guess not. 

Does the native Fedex plugin (PX.FedExCarrier.FedExCarrier) in 2022R1 return negotiated rates?

We have a customer that ships in varied box sizes as well as custom sizes to accommodate their products.  The Package entry screen does not allow the user to change the dimensions and there is no option for entering a box on the fly.  How have other users handled this in the Integrated Shipping?

We have certain Sales Orders that will include many items and will be shipped out in groups over a 15-45 day period. I’m struggling with the Shipping Rules. When the shipping rule is Cancel Remainder, the entire SO will be marked as Complete after the first partial shipment. The SO must remain Open as we are required to ship additional items on this SO. When the shipping rule is Back Order Allowed or Ship Complete, we receive an error message on partial shipment.I understand this error message on Ship Complete, but why would this error be there on Back Order Allowed? How can I configure this SO type so it can handle multiple shipments? Acumatica 2021 R2Build 21.220.0010