Distribution

Hello Everyone.I would like to understand the functionality of Avg cost in sales order I have reviewed the Stock Item Price cost and observed that avg cost is 256.85 but in My sales order when the SKU is selected it is showing 303.50Further, I verified and observed the avg cost value is coming from the inventory summary- Estimated cost columnJust want to understand why the estimated cost value is not updated on the avg cost details under that SKU or else do we have functional calculations on this?Any thoughts on this? Also, share the ar

I have a customer who wants to be able to print out inventory item labels directly from the PO Receipt screen.They have developed a report (label) as a stand-alone screen where they can select the receipt number and it creates a label for each line on the PO receipt with the total line qty. They aren’t concerned at this point with have an individual label for each item received, though I’ve seen a number of suggestions on ways to do that on the community.However, I haven’t seen anything on how to incorporate this on the PO Receipt screen.I have tried doing this myself with an Action in a customization but the parameters don’t allow you to select the inventory item on the detail line to pass to the report (label):Am I missing something? 

Can holdiays be blacked out when putting in an order so that we do not have a ship date of a date we are not in the office?  

Hello,  We had our ACM set up via a third party so have had little training on any sort of customisations.  How do we change the invoice layout they have created for us? We need to add our own bank details on there so customers can pay us! 

 We are currently working with a client who wants to configure a vendor-consigned workflow in Acumatica using the out-of-the-box functionality. However, we have encountered a challenge in setting up the workflow due to the accounting treatment of consigned inventory usage. When the vendor's consigned stock is consumed in a production order, the system creates a Journal Entry that hits the Cost of Goods Sold account. But when we subsequently bill the vendor for the inventory used, the Accounts Payable bill also hits an expense account, resulting in a double recording of the cost. Any suggestions on how to manage such a scenario in Acumatica. 

Hello,trying to add a document level discount to a SO Import Scenario where the SO could have multiple lines. Not sure exactly where to put the discount in order of operations, but i’ve been trying to follow the order of tabs in SO screen.   I have also tried to put the discount above the ‘line details’. In this example the SO will have 2 lines, and i’m getting following error on the 2nd row (this example puts the discount after the ‘line details’ are entered - see XML):  I have attached the XML for reference. Any help is appreciated!Cheers,k2​​​​​​​

Does anyone know of a way to handle the new CO Retail Delivery Fee ($.27 beginning July 1, 2022) either with Avatax or without? Avalara had sent out communications regarding this which stated to perform the following: Merchants subject to this fee will need to add a $0 line item to their orders with the OF400000 tax code. I’m unsure as to how this would be done in Acumatica. Perhaps someone from Acumatica may know if there will be something released in a new build perhaps? 

Does anyone know how to make the Qty to Supply field in Prepare Replenishment round down?  Currently any decimal amounts for parts with a UOM of ‘EACH’ is round up to the nearest whole amount. We would like it to round down.  Is there a way to do this? 

After setting the Payables Price Settings to fixed for "0" months, I can still only see the last vendor purchase price that was used to purchase from a Vendor. On the Inventory Stock Item - again I can only see the last Inventory price that was processed by the system. Since by implication the preferences indicate that the vendor purchase prices are retained, please advise where the list of those retained prices are for dealing with a vendor (It cannot be in the stock transaction history, as that does not relate to the Vendor)?

I know how to create volume-based price breaks for individual items in the Sales Prices worksheet. However, it would be a lot more convenient if we could set volume-based price breaks at the item class level. For example, if the customer orders over 1000 lbs, then reduce the base price by 10%.Is it possible to do this in Acumatica?

We operate a wholesale business where all of our customers are assigned a discount level off of our list price.  Some customers also have customer specific prices on a few items that we have negotiated.  This was a simple structure to manage in quickbooks using pricing rules but seems to be very complex to set up in acumatica.  Wondering if anyone else has come up with a good way to make this work in acumatica.Our challenges:Utilizing Sales price worksheets we can set up a worksheet for each discount level using customer price classes.  We can also set up a customer specific worksheet for the special pricing some customers receive. Both of these function perfectly.  Our problem is that we add items on a daily basis and using the above method we will have to manually create a new price worksheet for every new item we create.  Utilizing Discount codes we can set up a discount code for each discount level and assign those to our customers however th

Currently when using the scan and issue or scan materials screen, Acumatica defaults to adding 1 unit to the line that you have scanned. In our industry, nearly everything is weighed out and we need our operators to always enter the qty that is on their scale. Is there a way to adjust the settings in Acumatica to default to setting the qty in the scanning modules?

Is there a way to record in a purchase receipt the country of origin of parts received? Sometimes I’ll order parts from a vendor and I won’t find out what the country of origin is until I look over the packing list. 

HICan someone please tell me why is there a default Sales account and Subaccount on Sales Order type screen?and that it takes preference over Item's Posting classes?What is the logic behind that?  

I have queried both tables separately but can’t find anything that matches between the two.Thanks for your help 

Hello Everyone!I have query, hope you guys can help me out. We have an existing inventory list, all of which LREX is not enabled...but now we want to enable the LREX monitoring, is this possible? What are the conditions e.g. should the qty be zero? is it set in the PO stage of getting new qty of the inventory item? Are there any more conditions? Also how can I apply the LREX monitoring to the existing qty of items? Thanks in advance!Kind regards,Mrivera67

Introduction:I wanted to pull a specific list of inventory items from a generic inquiry.  Problem: I tried to use "Is In" operator for a condition. However, it does not seem to work as expected. (I tried various combination while profiling and could not get the SQL to translate to [column] in ('test123', 'test456', 'test789')) If there is a way to use the "Is In" operator, please share. Solution:Add a parameter to enter the list of items. (Set the Schema Field to InventoryItem.Body for maximum characters) In Result Tab, add a column that utilizes "InStr()" to search for the InventoryCD in the parameter field. (Convert to CDec() for better filtering)Paste a list of item numbers and filter the formula column “greater than” zero. I hope this helps.

How to create a Template/Report which will combine Parent and Child Purchase orders with inventory Id’s.

I’m not sure if I’m terming this correctly, and I’m also not sure if this is addressed in purchasing/receiving or if this is separate and is more of a kit consideration.We are a service company.  The scenario is that we purchase an item from a supplier, but sell the items components as separate items in our system.  My thought would be to create a “reverse” kit that can be “assembled” to negate the purchased item and increase the component count, which is the opposite of the normal assembly process for non-stock kits.For example;  We purchase a repair kit/item from a supplier, which contains a bolt and a bracket.  We will receive the item, however we want to stock the components as inventory.  We will then use/invoice either the bracket, or the bolt, or both, however those pieces will be invoiced as separate items.Any thoughts on how to make this work in Acumatica 2022r2 (or beyond)?   

Lease management and property sales can Acumatica ERP suite such business cases? If it suites, then how it will work?

Transfer of goods through vehicles have certain taxes (E-way bill) in India. Can we track this bill in Acumatica ??   

Hello,I am trying to get an unbound field to populate with availability on the sales order line based on joining to the INSITESTATUS table. This works on pxdefault- however, it begins to break down when I’m updating allocations on the sales order and am pending a commit. I have a sense that there is a view that is being manipulated as the order is being input keeping things in sync before they are committed to the database and I just can’t seem to find anything written about it. Does anyone know what view is being updated to reflect the item availability information at the bottom of the grid? The end goal is to trigger an approval rule based on the availability. If there is any other way of doing this, I’m open to suggestions. Thanks in advance!

HI everyone,I have a customer implementing Acumatica and they have a need to be able to ship from various warehouses on the same order. They need to be able to keep track of inventory though. If we used the buildings in Acumatica, what is the best way to process this?The Building Name would be Main, then each warehouse would be A, B, C?Does anyone have thoughts or ways to work around not being able to combine warehouses on shipments?

Hi TeamLooking for an Import scenario to update the Sync field on the ‘BOPIS Store to Sync’ grid.Thank you.Screenshot for reference