Distribution

We are new to acumatica and trying to use the Purchase Request / Requisition process. In our legacy system the users will make purchase request for known and unknown items. In acumatica we are able to make the requests for unknown items however, when our purchasing personal try to create the requisition from the request we get errors as the ItemID does not exist. Is there a workflow where you can take the request item information and create a new item from it? Or does anyone have any ideas on how you could allow requestors to make a request for non-existing items or vendors?

We are a company with multiple branch locations, some in different states. Most of the branches all perform the same selling functions, and we do not separately report financials for each branch (although we do some rollup reporting on each branches financial performance).There is a question on whether we should be using branches at all. For example, we could structure the software so that there is a single company with multiple warehouses (i.e. Seatle, Portland, etc), but no distinction between branches in the software.This would allow us to do single-step transfers between warehouses, for example. However, there is a question in my mind of whether this will hamper us in the future in terms of shipping material between branches (will the software be able to understand that the branch warehouses are geographically distinct if they are not attached to separate branches)?Does anyone have experience with doing this one way versus ther other? If the only advantage o

Hi, I first want to create a GI to show the top selling stock items at the top of the inquiry to the lowest selling items at the bottom of the screen. What would be the condition for this GI? I have attached a Generic Template that will be modified to reflect this. Let me know. After this, I will create a dashboard. i don’t need assistance for this now.  Thank you,Frances Pantelidakis  

Under Acumatica 2020R2 version , user just define one company which belongs to ‘Without Branches’ Type ,however while create a new sales order /direct invoice ,system will pop out the warning shows that [Branch ID cannot be empty ]at the moment user clicks on Save button to save the sales order .End up the order is saved but what may be the reason trigger such warning . Do refer attach for issues showing .Hope can get some advice for this .Appreciate.

Removing Stock Items

In order to get the volume discount from the Vendor we have to place a single PO with max Qty . In the case of Purchase Requisitions system is treating it as a separate channel for creating a PO. Is there any option to add the  Purchase Requisitions to Include in MRP so that PO will be created with max Qty to get max volume discount ?Please correct me if I missed anything ?  

Using v2021 R2.  I’ve configured DeviceHub and Acumatica for the label printer.  The user profile has the printer as the default printer.I’ve set the “Print Shipment Labels Automatically” flag in SO preferences.I don’t know if it is required, but I set the User Settings in Pick, Pack, and Ship to Print Shipment Labels Automatically.  We’re not using Pick, Pack and Ship.When I click on Confirm Shipment, labels don’t automatically print.  Is there another setting I’m missing?

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 working

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 alr

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, Ad

 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 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)!

We have a customer that delivers product from their own truck.  They need to print an invoice from the truck once delivery is complete.  Is there a way to print from Acumatica, on a tablet to a blue toothed printer?

I have a situation where I need to have add a second AP bill to a Landed Cost Entry. After I create first AP bill, the landed cost is no longer available to be used.  I tried a partial amount.  I cannot change the qty.?

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