Inventory, Orders Management, Warehouse Operations
- 646 Topics
- 2,199 Replies
I am trying to figure out the best practice to structure my data for a scenario where I have many ship-to locations for individual billing addresses for a company.It seems to me that there are two possible ways to do this.The first would be to create a new customer for every ship-to location and then use the “Parent Account” relationship to link it back to some master account. Is there a way to derive the billing address from this parent-child relationship (child inherits bill-to of parent by default?) What are the options/consequences for financial reporting with this setup? The other way to do this is with the “Customer Locations” feature. So I would create a single Bill-To Customer, and then attach all the Ship-Tos as locations to that customer. The main issue I see with this is that I don’t see a way to attach Contacts to individual locations with this system. So if you have a large conglomerate with a bunch of different locations, there doesn’t appear to be a way to default or sub
The company purchases consumables in bulk e.g. stationery, refreshments. Once received into inventory, employees request these items with the employee's manager approval. The request also should specify the expense subaccount. Inventory clerk should then be able to pick up the request and issue quantities on request or less but not more.Creating an "internal" order type seemed brilliant, selling the items at zero price. The only drawback was all order types including trade orders use the same shipment numbering sequence. How best can this be setup?
Hi All, One of my team members, Michelle Hesketh, created a ‘How To” blog article on Landed Cost and Complex Calcuations. I hope you all find this information helpful. Imagine you run a company headquartered in Puerto Rico with an additional location in Jamaica. When you ship items from Puerto Rico to Jamaica, what should be a simple cross-company sale suddenly becomes a massive landed cost calculation. Every item you ship to Jamaica is subject to freight, customs, duties, and tax charges – and that drives up the average price of those items. Problem: It is not uncommon for a “straightforward” landed cost transaction spreadsheet to contain 70+ lines, resulting in hours of manual entry!Solution: With just a little bit of initial work, it is easy to configure landed costs in Acumatica, saving hours of work and reducing errors. Summary of Steps (for more detail, see the full guide below)Create a new landed cost code Link a vendor to your landed cost code Decide how you want to enter la
Does someone know what is the actual formula for import Vendor Attributes?I want to import lots of the data on Vendors - ATTRIBUTES - Vendor Products highlighted as belowI have tried, but come out error Formula of import scenariosCR Error: One or more Attributes are not valid.
1.WE selling non stock item， I have confirmed that in non stock item [general setting], require shipping is blank2.When I create a SO to sell non stock item, the status becomes [Shipping ] and I can’t execute Prepare invoice. and can’t delete this sales order, What should I do?My current version is 20.210.0044Thanks!
Hello Everyone,Can we change the Sales Order screen tab sequence order without changing the UI fields order?Currently, in the Sales Order screen when we click on the tabs, the sequence will be..Order Type → Order Nbr → Date → Requested On → Customer Order Nbr and etcWe would like to this change to below sequenceOrder Type → Customer → Order Nbr → Location → Date and etc Can anyone help me with this?
We have a situation where customers come into the facility multiple times/day or week to get product. We are just using an Invoice type sales order (no shipments) to record the shipment by entering warehouse/location in the sales order. Upon prepare Invoice it creates invoice and processes inventory issue, etc. This works fine one by one. However, we would like to be able to create consolidated invoices for the day/week using Process Orders screen. I know that we can choose Prepare Invoice in that screen and it will create one invoice for all the orders for that customer that met the criteria entered on top. We need it to apply additional grouping. For example, in one day or week, 12 sales orders/invoices, 5 have PO/Cust Order Number 1234 and 7 PO/Cust Order Number 5678. If I just ran wide open it would create one invoice with all 12. I need it to create 2 invoices, one for each PO/Cust Order Number. Actually, these are all for Projects and I'd need that to be the first group
Receiving message:'One or more lines have unassigned Location and/or Lot/Serial Number' error when saving an inventory adjustment transaction The Adjustment is to add a quantity to a valid Location.The QOH for the item is -0-. The purpose of the adjustment transaction is to have bring the inventory records to reflect the proper actual QOH.Is there a means of assigning a location to be valid for a given Inventory Item?The location was previously used to record a quantity of the same Item before it went to zero.
What's the difference/purpose "Include in Qty. Available" and "Sales Allowed" for Warehouse Locations
We’re finally starting to get a handle on Availability and Alloctions...I think We have a DEMO location with items we do not want included for normal Sales operations, but do occasionally ship to customers or distributors. Unchecking the “Include in Qty. Available” is a necessity since we do not want these items to be considered as available for normal Sales Orders. However, with “Sales Allowed” still checked, we can add the items from that location to a Sales Order, but we cannot create a Shipment. The documentation says this:Include in Qty. Available A check box that you select if the quantities of goods available at this location will be included in the quantities of available goods and used in shipments and transfers. Sales Allowed A check box that you select if only issues (direct inventory issues as well as the issues generated from sales orders) are allowed for the location. You clear the check box if no inventory transactions are allowed for this location, except for i
How do you create a filter for a GI/Dashboard which returns results for Yesterday, or Friday if Monday
I am looking to add quotes, orders, and sales from the previous workday on to a dashboard. We work Monday to Friday. I have used the “date” equals “@today-1” which works for Tuesday-Friday. However, when using it on Monday I do not get any results because it is looking at Sunday instead of Friday. Is there a way to add a condition to the filter so that it only looks at weekdays or an If statement so the previous Friday result if it is Monday?
Hello, As we verified, by clicking the “customer statement” button on customer screen, the system always prints the report version with the statement date largest. However,a user prepared a statement on 2/5/2021 and chosen 12/31/2021 as the statement date, which makes it always the latest one. Is there a way to delete this statement?If this record exists, the user always get an incorrect version of statement by clicking the “customer statement” on customer screen.
Hello everyone I am struggling with my export scenario that I created to export shipment records (detailed records) since I want the PO numbre , product code and shipped qty. However, after preparing the export, I have the same product codes (same lines) of the first shipment on all of the shipement records. (same 3 products are repeated everywhere) There is something wrong with my scenario but I can’t find it. Please HELP
I’m trying to add Sales Categories to my Inventory items with an import scenario using the Stock Item screen to add items to my already created categories but have had no success. Has anyone succesfully been able to add stock items to sales categories with an import scenario?
We have employees that use the numbering of the lines on a sales order to help ensure accuracy when entering a large SO.Our employee Lisa entered SO 102812.The line numbering was not sequential (I guess the line numbers "skipped" from like 11 to 20 something)But I look at it today and its varied with line #s missing throughout.I then looked at the audit history, to see if lines had been deleted or something. But honestly I can’t really make a lot of sense out of the audit history detail. Would you be able to identify why lines would not remain sequential?Not only with this specific sales order, but in general, what would cause this?
Hi, Need to remove Inventory following allocation transaction. Actual Transaction is not showing this. But it is showing Inventory Balance Report. No need to show this Item. We disallow Item Negative balance in item class Level. Inventory Balance Report Item Class Level.
Our Approval Map for PO Requisitions has been working well, until we wanted to wait until after bidding is complete. Desired process is:Requisition Created Sent for Bidding Bidding Complete, Price Finalized, and Vendor selected Management ApprovalSo far we’ve been unable to delay triggering the approval to after bidding is complete. We’ve tried several combinations of Steps and Rules, but it appears to want to go directly from On Hold to Pending Approval.Is there a way to accomplish the flow outlined above?Thanks very muchAndy
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.