Inventory, Orders Management, Warehouse Operations
- 1,436 Topics
- 5,566 Replies
How does one deal with 2 uom’s where the conversion is not constant?Example Steel industryA pallet of sheets never weights the same. 100 sheets might weigh a ton with one PO Receipts and then next week 1.01 tons.Also, what would be a solution where I Order in kg’s, I sell in Kg’s but I stock count in Sheets/each. what would be a good option for the base UOM? Remember I have variable UOM Conversion factor.
Hi, Version-21.209.0034 Am trying to connect With Azure blob Storage to use the container in iti tried all possibilities //var connectionString = "rcwcafz1t/ZdikEzhS181NGFdtiqG77sEznq200HJzUl88wz+BvlTJULGeVbxZdzFRp/0MYMbkrQ+ASt9uIDVg=="; //string containerName = "inkitnew"; //var serviceClient = new BlobServiceClient(connectionString); ////var containerClient = serviceClient.GetBlobContainerClient(containerName); am using Azure.Blob,Storage from NugetPkgAm able to build the code in visual studio when am trying to check screen level am facing an issue And also tried using above stack overflow link.. this is also not workinghttps://stackoverflow.com/questions/70097124/how-to-connect-to-blob-storage-container-using-c-sharpPlease help me with Possible answersThank you
2021R2 version. We receive an EDI 850 from our customer. Through True Commerce APIs, we create a sales order in Acumatica. Later, we receive an EDI 860 change order from our customer. Our business does not want this change order to be automatically applied to the existing sales order in Acumatica.Instead, our business wants us to generate an exception report that lists the content of the 860 (e.g. header info, line item data) and generate exception messages where the 860 change order is different than the sales order on Acumatica. For example, provide exception message that the line item quantity changed, or that a new line item was being added to the sales order. This exception report would go to the customer service rep., who would review the changes and manually enter them on the Acumatica sales order if accepted. Has anyone already built functionality that creates custom change order tables (header, lines, notes), and then matches this to the sales order already existing on
We are experiencing integration error regarding Tax Detail ID’s between Celigo and Acumatica. It seems that Acumatica cannot find a match for the Tax Detail ID being passed from Celigo which is causing the errors. This has been working fine for the past 2 years and the issues started in early to mid April. Celigo and Acumatica claim that there have been no changes made on either side to cause this to stop working.Is anyone experiencing this as well?
I was wondering if there’s a way to create a matrix of Environmental Handling Fee being added to the Sales Order (or Sales Invoice) when certain Stock Items are selected based on the State value of the Shipping Address.Tried with fixed tax (doesn’t work for Qty other than 1) without a success.Pointing to a certain direction in setting such functionality would be gratly appreciated. Mike
Hi everyone. It seems we get a decent amount of orders where the ship-to addresses are incomplete. That causes to notify CS. Then CS digs around by either finding a previous order or reaching out to the customer.Then we'll be sure to edit the customer account in acu/bigc. Just slows the process down in general.It's been discovered these only have a street number.We think it has to do with the customer using an autofill feature (browsers unknown), but not selecting the full address choice. Maybe just hitting Enter and moving on quickly. Just a theory.Any thoughts?Thank you.
The Email Notification Template for Sales Orders that is being pulled is not the one we have setup in our system. It was working fine around 2 months ago and no known changes were made. I have verified that the Report Settings under Sales Order Preferences is set to the correct notification template and is “Active”. None of the notification templates that we have setup regarding Sales Orders use the wording that is pulling up now. It is not a customer specific issue - it is happening across the board. Any other ideas of where I can look to get this fixed?
We are a retailer who use the Distribution and Ecommerce modules. We have implemented a leasing program where customers can lease the product vs. buying outright. In this scenario, we ship the product to the customer and then “transfer” the inventory to a virtual warehouse so that we can account for it. We started using the TR order type but this is very cumbersome. Are there others who are leasing products to their customers and if so, how do you track it? We have looked at LeaseQuery, but it is not the right solution because they are more for if we were leasing the product for our use. TIA
Client will be using Shiphawk for packing. The need to generate batch pick lists in Acumatica. The workflow would be:Generate batch pick list in Acumatica Pick product on paper Accumulate product in packing area Sort and process packing of product in Shiphawk to confirm shipment in AcumaticaThe issue I’m running into is once the shipment is created and a batch pick list is generated, the shipments on that list are essentially locked until scanning is done to complete picking in Acumatica.Thoughts? Am I missing something simple?
Can anyone explain if the In-Transit Branch default under Inventory Preferences has any impact? I have a multi-branch company and of course would have any number of branches that would be in-transit when transferring or purchasing inventory. I don’t understand how 1 default In-Transit Branch would even apply much less make sense to be mandatory setup under Inventory Preferences. thanks for the input
Greetings everyone!Looking for feedback from the community with regards to management of Kit Assemblies. I’ve scoured high and low and would love to hear what you have tried and what has been learned in the community.When configuring inventory and warehouse settings how do you establish inventory visibility to the subaccount level for kit assemblies? Currently, the only clear identification of the kits I can identify is the  Is a Kit checkbox?  I see potential options of using Base Unit, Posting Class or Item Class to support the accounting of kits at a subaccount level. I’ve given thought to using reason codes in the kit assembly process to facilitate accounting of Inventory to the Subaccount level, curious why that isn’t inherent in the system. Disassembly is organic, so why isn’t assembly organic? When I dig into the reason codes, I find myself limited by the available options [Sales, Credit Write-Off, Balance Write-Off, Issue, Receipt, Adjustment, Transfer, Disassembly, Vendo
I am trying to use Paperless Picking for the first time and ran into this issue.Create a shipment and removed hold. Create pick list and sent that shipment to the pick list queue Manage pick list, assigned the shipment to a user/picker Login in to the mobile scanner and launched the app - Warehouse / Pick, Pack, and Ship Click Next List Scan nearest location Error, see trace for details (no trace in mobile scanner) The Hold was removed from the pick list in the shipment, am I missing something. Much thanks,Nelson
Is there a way to update the salesperson assigned to a group of customers in bulk based on state and/or zip code? We pay commissions based on the salesperson assigned to a customer account and need to change a group of accounts to a new salesperson.I set up a generic inquiry based on AR.CustSalesPeople pulling in the needed data from the location, customer and address tables. The inquiry returns the expected data and can be filtered for the needed records, however I’m not able to setup the “Enable Mass Record Update” operation successfully.What “Entry Screen” should I be using or does this need to be done using an import scenario? (I tried AR.20.50.00, AR.20.50.PL and AR.30.30.00.)Any suggestions or guidance would be appreciated. Thanks!
Let’s say that we have 2 different warehouses, MAIN warehouse, and another warehouse in a different city that is SECONDARY warehouse. We create a sales order with 9 items from MAIN warehouse, but one item is only available in SECONDARY warehouse. We want to transfer the stcok required from SECONDARY warehouse to MAIN warehouse, for inclusion in the customer’s order for one consolidated delivery all at the same time.Is there a way to transfer this inventory from SECONDARY warehouse to MAIN warehouse, for consolidation into the single order automatically? (the alternative of course is to transfer first, and then add to the customer’s order, but this runs ths risk that someone else grabs that inventory after the transfer to the MAIN warehouse).
I am interested in how the community is using Acumatica WMS and their experiences with it. Please share!
I would like to know which industries Acumatica WMS is being used in and how it’s going. Please share any experiences if you are using it live to ship product (or if you are in the process of setting it up)!
Hi, We are going to have clients log into to Acumatica. But they will need to view only their customer account in Receivables and their relevant stock and non- stock items related to the item class. Here are the screenshots for my Restriction Group Setup for Inventory Item by Item Class. Note there is only ONE company not multiple companies. Here is the user that will only have access to the TXC item class. Here is the setup to restrict access to the item class. Note nothing was done in Inventory Items since they are grouped under the Item Classes. When I log in as that user all of the inventory amounts still show. What am I doing wrong any help would be appreciated:
Hi all, Can you help me about the Tally of records in Inventory Summary to Purchase Receipts because when I create a Purchase Order then Purchase Receipts the quantity is correct but when I go to Inventory Summary the total of Purchase Receipts is double (Please see the screenshot below) This is the total of Purchase Receipts (On-hand, Available, and Shipping are 100) But in the Inventory Summary is double the digit of quantity that I received in Purchase Receipts and in the Inventory Balance are the same reports Please help me to fix this bugs.
Hi, I’ve found some instances where a user deleted an item of a SO while not canceling the drop-ship PO. This could be very common when dealing with high volume ecommerce shipments. Is there a way to prevent this from happening? Workflow should be Cancel PO > Remove Item from SO
I have a IFF here that is working for formatting the cell in yellow=IIf( [POOrder.Status] = 'N', IIf( [POLine.PromisedDate] < Today(), 'yellow40', 'default'), 'default') What I want is to highlight the cells that are +14 days from today.Like you can in a filter @Today+14 Thanks
Here is an example item. I have created a number of purchase orders for this item, and then I received them. You can see there are 3 purchase receipts, all of 1730 LBS of this item. Then we have 1 sales order for 346 LBS of this item. The “Available” quantity of this item is -346, and the Available for Shipping is zero.Can someone please help me understand why that is? On receipt, I assign a Lot/Serial number to these items. Does this somehow segregate this from the main inventory calculation figures? If I have received 1730 * 3, and I have one order for 346, then why is my Available still negative and my Available For Shipping zero?P.S. There was a warehouse attached to these records, but I have redacted it. Just pretend its name is DEFAULTWHSE for the purposes of this discussion. Thanks,Jonathan
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.