Distribution

Hello: how create a transfer from sales order, but the item comes from secondary warehouse? Best regards

We are trying to extract and update the base sales price using either ‘Sales price’ or in the ‘Sales price worksheet’ then using the copy prices option.  When we click on the ‘create worksheet’ or ‘copy prices’ we get the below error:An error occurred during processing of the field UOM value LENGTH Error: UOM 'LENGTH' cannot be found in the system. Please verify whether you have proper access rights to this object.We have tried to change the UOM for the rows with Length but we just get the same error but with the UOM we changed it to mentioned.Any suggestions?

Hello all, The price multiplier does not seem to work when I change the UOM. I have ensured to enable it in the SO preferences, and the item has a value in the price multiplier. Am I missing anything?Item at base UOMItem when UOM is changedPrice settings in SO PreferencesConversion setupAny help would be greatly ap

Does anyone know of or have a work around for default locations for transfers? I am talking specifically for automated operations. Acumatica has a default Issue from and Receipt to but there are no other defaults that I can see.  

How do I search Inventory ID from Sales Order line to find data contained in respective Item(s) LONG Description and/or Item ID Attribute ?

Hello expert.How cant I get data field in the “details” tab screen AP301000 below image? How can i fetch data each row? Thank you so much. 

Hi Community, please assist. I have setup an Import scenario to import vendor payment details into the system, However upon import, it imports the first Record and gives me an error for all other records. I have checked the formatting on my file and i think its ok. There is no difference between the first  record and all other records. PLease assit. What is it that i am missing 

I’m trying to create a GI (for a dashboard) that lists Inventory Transfers that have not been received. I’ve used my imagination and looked at tables in the DAC browser, but haven’t found what I’m looking for. Anyone have something to share? :)

From my brief research and testing it would not appear that Acumatica allows for a workflow where Landed Costs can be entered and paid for prior to the purchase receipt. Has anyone figured out a way to accomplish this cleanly?  Like many companies, we are importing items from overseas and paying some significant landed costs in the form of freight and duties. We want to capture these costs and apply them to our item costs, but often we need to pay bills before items are received. Neither the freight companies or the brokers are interested in waiting for us to receive the inventory before they get paid and I imagine this is a very common scenario - is this a simple oversight in the Acumatica functionality? or have I missed something obvious?  Appreciate any insight others have in this area   

Hello,is there a way to automatically check the “mark for PO” checkbox in a sales order if the entered quantity will result in a negative stock qty? The sales staff tends to forget to check the box every now and then. I am looking for a way to make sure no items from SOs are missing in our POs. thanks for your help. 

Looking for a report or GI that would show available inventory for components of a kit. I can’t seem to locate anything like that but it sounds familiar.  Am I missing something or does this not exist? Original question from client: I want a report that shows my available inventory on hand for all the components in a kit, all on one report. 

Ill get straight to the point with an example. (Totally made up for simplistic purposes.) Somebody orders ten 6 packs of Peeps. They are $5. Order total $50.We charge them $50. But we are out of 6 packs, so at no extra charge, we send them ten 8 packs.  We process the order as the 6 packs they ordered, But we want to keep the 6 packs at 0 in inventory, and deduct 10 from the  8 packs. Is there a simple way to handle this?

Is it possible to set a default warehouse only for transfer order?We knew their location configuration at the warehouse level. Looking to see if there is a way to set a default location only in case of transfer orders.  

Hi Everyone,Can I make an automation schedule for the Prepare and Process of Base Sales Price entity? I can’t find it in Automation Schedule screen in Acumatica.Thanks in advance.

Hello,       We are using “shipping terms” to charge some specific customer handling fee of 2% of item sold.     Normally, it would be fine. But this Invoice amount would contain “non-stock or service” item, which should not be charged.      How can we just count the  freight price based on ONLY sotkc items?

Hi Everyone.  W are looking to enable the Acumatica physical inventory module in our company.  It seems that the inventory selected to be counted will be locked in the system during the process and we typically count during our operating hours.  I wonder how others have dealt with this issue.  Any feedback or experience you may have with this module would be appreciated

We have multiple locations that we ship to for one customer, and this customer has three different UPS collect account numbers.  How do we set that up in Acumatica so it works with EasyPost? Thanks,Frances Pantelidakis  

Facing an error While creating a purchase requisition,can’t able to add creator but we hired employee . how to resolve it ?

Hello to all, I have the pleasure of joining on with a company utilizing Acumatica*. We are very much in the beginning stages of setting up and creating part numbers with designated vendors and just like myself we are new to this process and system. My question here being, using Acumatica is there  a way to register each individual part number a purchasing group or MRP controller much like SAP to better maintain material requirements. 

My client needs to be able to issue a refund to their customers before the product is received back in.  We were trying to use an RC order type and on the general screen you can select a box to “allow refund before return”.  Has anyone been able to get this to work.  The prepare invoice selection is still grayed out and we can only get the credit memo issued once we complete the return.  They need to track when the product is returned and it is serialized product but they want to issue the credit before the product is returned.  If anyone has successfully setup this workflow can you let me know how you did it?Thanks, 

When entering a PO or vendor invoice, I would like to use the Alternate ID that is referenced below. I was under the assumption that this was possible, but when trying it out I receive ‘No Results’ when typing OW092 in the inventory ID. Any thoughts would be appreciated!  Jenny  

I am trying to convert an attribute on the customer record to a doublewhen it appears on a GI so that the data can be sorted with it. I have tried using the formula editor and using the convert formulas, but the don’t seem to work. I get an error saying “Error: The virtual field SALES2020_Attributes cannot be used in a condition expression.”, SALES2020_Attributes being the name of the text attribute. This is what the formula looks like in the formula editor: Any help would be appreciated! 

When I enter a PO for a vendor and add a detail line for a stock item, the cost for that item is brought in from somewhere.  I thought it was from Vendor Inventory, but if I go there and select an item and click the Price/Cost tab, it will allow me to edit and save Last Cost but when I create a new PO that price change is not reflected.  Where is a PO taking its default costs from, and how can I change it?  Thanks.

Hi Acumatica Support,As per checking the audit history is not available in the Vendor Access and Customer Access screen in Row Level Security. Is there a way to set a trail in this screen?Thanks!

Good day,I am having little trouble getting the Unit Cost function to work.  Can someone direct me to the security access area.  Or is something else.  It doesnot allow me to put a pending cost and data.  I have a number stock items that need updating.Thank you@Evan G