Distribution

Hello All,Normally we will get the Landed Cost around 3 - 5 days after receiving goods.If we sell products during that time, the item cost will exclude the Landed Cost.Then, when entering the Landed Cost for the sold items (that item does not exist in the system anymore), the amount number of this Landed Cost will go to an expense account.In this case, the cost of goods sold will be wrong.Has anyone got this situation? The additional case for those who use the module Construction. When the amount number of this Landed Cost goes to an expense account, there is no project ID. Therefore, you can't allocate this expense to a different project. Thank you in advance for any ideas that will be posted.Many thanks,Yên Chi

We have a client who is using Avalara to process sales tax and they have requested a report or inquiry showing monthly sales by ship-to state that will allow them to audit Acumatica sales tax versus Avalara sales tax reports. Has anyone created anything like this?

Hi team, We have a scenario where a vendor has two points from which they distribute stock to us. Location A is denominated in euro, location B in USD. Looking to support our procurement team by setting defaults for currency which follow the location field for vendor rather than default at vendor, and then allowing override. Before you suggest splitting the vendor into two, it can occur that for speed of delivery they switch locations and thus the order currency. I understand it is difficult/not possible to switch a PO between vendors once issued so we didn’t think that met our needs - but correct me if that’s wrong.Thanks!

Is there a way to view MRP Details from any prior date MRP was generated on?  I would like to be able to show what MRP was recommending (and the Detail Inquiry to support that) from a previous date.  For example, see what sales orders were driving the demand that may have been changed or deleted?Thanks

Hi team, Our logistics team has a use case to re-route/change the destination warehouse of our imported inventory. Is there a way to update the destination of a TR or let any location receive a TR? Our current solution would be an additional 1 step transfer to adjust planned to final destination however this would cause issues with recording landed cost as well as being additional admin. Appreciate the help!

Hello all,I have been looking out for ways to not allow anyone create an SO for a particular customer if that customer goes on credit hold. Only AR Admin should be allowed to remove the credit hold and create/process an SOThanks in advance.

We need help with how to book purchase discount in the following two situations:Suppliers will offer a 25% (for example) discount if we agree to take a large amount of product.  We want to book this special discount as “purchase discount”. How do we do it.     Suppliers will offer us a 50% discount on freight charges if we pay the product invoice within X days.  We want to book this 50% freight discount as purchase discount.  How do we do it? (We use landed cost to compute cost.)Your suggestions are greatly appreciated. 

Can anyone think of a solution for high volume eCommerce fulfillment that groups orders by shipping container size?1) Place sales orders on hold for anomalies (bad address, possible duplication, candidates for consolidation onto a single shipment, etc.)2) Calculate the exact box to use on each sales order (there are 11 box sizes, 8 product shapes) (customers frequently order the same thing on a scheduled subscription)3) Create one shipment order fulfillment queue per box size and carrier

Is there a way to change settings in the Purchasing module to have any stock item that is at a negative quantity (i.e.outstanding sales order for the stock item that is not in stock or only partially in stock) to populate on the Create Purchase Orders screen? In essence, automating the “Mark for PO” check box on the sales order forms.

Hello AllI would like to ask if it is possible to set Sales Orders to be generated automatically fex. every month (same Customer, same Item, same q'ty etx).For non-stock item I would do it using Customer Contract. But I have no idea how to set it for Stock items.Is it at all possible out-of-the-box?I would be grateful for any tips.Thank you.

Is there a way in which the Quantity or Price can be checked or subjected to a threshold limit? This can prevent or reduce keying error entries. Perhaps the Limit on the Purchase Order should be enabled so e.g. If we already have a Max quantity in stock, then we should not be able to enter a new quantity to be purchased, unless their is already a sales order logged against the quantity on Stock, and then if so, that only the difference in quantity can be ordered and within a price range (otherwise requiring additional overriding authorisations).

Hi. Is there a way in Acumatica where I can partially receive a component item in a kit at Purchase Receipts transaction screen? Thanks!

Hi!I am working on figuring out how to make the following happen…I need to be able to have a map that assigns a sales person to the sales order depending on the customer account and which warehouse the product is coming from.  Anyone have any ideas on how to make that happen? Any help or input would be greatly appreciated :)Thank you!

We have a Dollar account and a Euro account.  We do a Bank Transfer from Dollar to Euro, enter the conversion rate, and everything works as it should.  Except our Euro bank charges $5 and we send it in the same transaction.  So if we want $1,000 worth of Euros, we actually transfer $1,005.  We tried adding a $5 detail line on the Bank Transfer but it still shows up as a separate transaction.  It would be silly to create a clearing account just to add these two amounts together, so we just deal with 2 debits in Acumatica Banking and 1 debit in Online Banking.  Does anyone have a solution?  (We don’t particularly want to modify the exchange rate to allow for the $5 either, although I know it’s another workaround.)

Hey All,I’m trying to create a generic inquiry for PO approvals. My goal is to link the GI to a business event to send to multiple approvers, owners etc. I have everything working except that the email address for the approver does not pull onto my GI.  Tables: Joins:POOrder to EPApproval   EPApproval to ContactResults: Email address is blank. Email is from the contact table. The contact table for the employee stores their email address.    Thanks!

I added some User Defined Fields on the Purchase Order document, however once I put the document to the open status these UDF are longer editable (same as other fields in the document header), I wonder if there is a solution for this, I need to edit these fields even when the document is in the open status.

I have been trying to get a transfer order Auto run to work and I have hit a point where I don't know what I have done incorrectly.Here is my parameters:Working with a Transfer order I have enabled Quick Process in the TR order type and the button appears on the top of the transfer order screen I have tested that the quick process produces a desired result of pushing the transfer order through shipping and updates IN appropriately when I manually press the OK button the process order screen.  I have started a customization project that once the transfer order is released it will pop open the quick process screen and then it stops.  In the customization I went ahead an found an action of OK (quickProcessOk) on the actions screen and set the auto run to true. When I remove the order from hold the following screen pops up but then nothing future happens.  Does anyone have a clue of where I may be off here?  The desired result is when the order is taken off of hold the quick process runs w

Hello, We’ve run into an interesting problem. Some of the Stock Items we purchase are sometimes sourced by more than one country. The ‘Country of Origin’ field on Stock Items is limited to one option unfortunately. Has anyone else ran into a similar issue, and if so, how did you go about resolving it? Outside of customization, I’m hoping someone’s had an interesting way of handling this that I might just be missing. 

I want to create a widget based on the screen AR409000, where all sales are summed together, regardless of customer class. If I delete the customer class in the inquiry parameters, so that the field is empty, the system does not implement this, I still only see the sales in the standard customer class in the widget. Does anyone have an idea how I can solve this problem?   

My client has over 3000 variants and will be converting their web site to Big Commerce.  I have added all of the Variants to the item classes but now I need to import the template items but it insists I have default column attribute - most of the template items have a single variant which will be the Row Variant.  How can I, turn off the Active flag and only have active the single variant I need for the Row.  Adding a dummy column variant would overcome the issue but them I would need to go back and somehow make inactive the variants and remove the dummy,  

We are new to Acumatica, and we have issues with emailing the customer statement. It says, "Error: The email account is empty...". Despite the fact that all of the customers' email addresses are incorrectly set up on the customer profile, are there any other places in Acumaitca to fix the issues other than the customer profile? I deleted the last statement and regenrated it several times, but it did not fix the issue. 

Why is the total Dead Stock Cost in the dead stock screen different from the total cost in the inventory valuation & Inventory Summary.I have a item that shows the same QTY ON HAND in the Dead stock, Inventory Summary, Inventory Valuation but the DEAD STOCK COST is 47K but the Inventory Summary & Inventory Valuation the total cost is 14Kwhy is the Dead Stock qty calculating 47K ? How did it get that number Does the dead stock do some sort of Inventory Holding calculation?  

Hello, I created a custom printed form and placed it on the site map. I added a customization project that allows this form to be printed from the sales order screen via the action menu > Printing & Emailing section. (This form is a copy of the sales order without prices). When I print from the Site map, the form prints correctly using the selected parameters. When I print from the Action Menu, no data is visible. I have updated the user access to the new form to match the original form that was copied. What am I missing? 

I have a purchase order that has a extended cost of an inventory item pulled up from the Vendor Prices screen . How to change this setting . I do not want the line item in the purchase order to automatically populate the extended cost from the Vendor Prices screen , instead i want the extended cost in the purchase order to pull the last cost/current cost in the stock items screen.  

Many of our customers find it very annoying that they have to manually touch the “Set Qty” button on their mobile devices in order to set the quantity being picked/packed/shipped. We are trying to include the Set Qty command (*qty) as a barcode on the picklist report so that they can scan that command and then scan the barcode for the quantity (since there’s no way to set the mobile device to default to the shipping quantity).I can’t find the right way to format the command on the report so that the barcode scanner will read it and put the device in Set Qty mode.Does anyone know how to do this?