Distribution

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  

Hello, I have added Three UDF’s and UDf’s Addition values am assigning in Default Price of Stock Item Screen Please Help me with the SolutionThanks,Version-22R1

When ordering major components on a project, I will “mark for PO” on the sales order.  After the product is received and sales order invoiced the PO link tab is cleared so you can’t go back into an old sales order to establish what PO the product was ordered in on.  When dealing with warranty claims, all of my suppliers require me to supply the PO number that the product was ordered on for traceablility.  Why is this field wiped out when going back to check a historical Sales order?

We have a customer going through upgrade testing for 2023R1 and they are receiving the error below when trying to confirm a shipment: This is what the configuration on the carrier looks like (and testing the connection was successful): Thanks for any assistance!

I own a manufacturing company. I uses vehicles on (own, rental, contract) basis. I delivery my goods to different logistics area through vehicles. my question is can I able to track my vehicle and also diesel usage ?

Is there any option to set the Vendor Prepayment Mandatory before processing the Purchase Order ?.(same like Sales Order Prepayment Setting in Credit Terms )

For most of our inventory items, our valuation method is Average Cost. However, for many of our POs or inventory adjustments we had incorrectly issued at $0 and therefore our average cost is significantly skewed and incorrect. The true correct average cost for our items is actually our Last Cost. Is there any way of manually updating average cost? How can we go about rectifying these incorrect average cost values?

Hi, Does anyone know a way to auto assign a Workgroup on the SO based on SO type? Right now, we have to manually enter the workgroup when entering that SO type order.

Good day,We have asked this question to Acumatica pre sales and they do not have a defintive answer and say we need to test this process. The current scenario that works is that Acumatica can recommend using Zebra scanners with the mobile app and it works using WMS, however the Sales order process is different and not tested.The client would like to achieve a process whereby they install the Acumatica mobile App onto a tablet or handheld device and then raise quotes and sales orders on the app, when they need to select the item to quote on they want to be able to use that same device to scan the barcode on an item and have that pull in the stock item into the SO/Quote. This would also be true for raising an invoice.They dont want to go the tradtitional route of a POS workstation that stands at a till point with a connected canner device as they require mobility for their sales team.Anyone else with this problem or have a solution?

On the more menu of the shipping screen, there is an action labeled “Get Return Labels”.I can find no documentation on what that is supposed to do.  Is it supposed to just print a label or does it do anything to data?Also, I get an error saying “Confirmation for each and every package is required.” when I do this to an open shipment.  If I have a Confirmed shipment open in the screen, the “Get return Labels” is grayed out and unavailable. Thanks for any insight!

Does anyone knnow where in the system I might be able to find the history of a physical inventory by item?   Is there a report or  screen where I can access that or pehaps someone knows the underlying table that I could look at through the DAC browser?   Any thoughts would be appreciated.

HI All,The Screen Sales Order always shows <SPLIT> on the Lot/ Serial Number Column.There is any way that we can show the content instead of <SPLIT>?Thank you,Yên Chi

Hello, I have a client that would like to invoice the non-stock item with the last shipped stock item from the sales order. Currently the non stock item freight is added to the first invoice created for the sales order. Is there a way of control this or do we need a customization? Thanks, Patricia 

I realize that the “Sold Since” date defaults to three months from the current date: Is there a way to default this to a different amount of time? A client may want to go back further, say six months, and not have to change this date every time.

A client would like to use FIFO for their inventory valuation method.  They use Batch control and expiry.  I have ticked the “cost sep” on the Warehouse location (they only use one location).When entering a Sales Order however it is only taking the cost of the first receipted qty.Is this the way the system works? I am assuming yes bc at the Sales stage the inventory has not been allocated yet so there is no way of picking up the cost?Regards,Laura 

When I display my custom report in acumatica mobile phone it show me the error like this object reference not set to an instance of an object. But this report I can run this report in web working properly.

Client sells to Distributors, Chains, Retail Outlets. They can ship the same item in a Pallet, Master Pack, Inner Pack or Each. For the purposes of compliance, they have to provide the weight and dimension of each of the shipping methods, although the UOM on the SALE is EACH. We have Acumatica and Pace Jet and are looking to see if someone has tackled this before and is there a way to best handle this other than attributes?