Community
Discussion Forums
Distribution

Distribution

Inventory, Orders Management, Warehouse Operations

1,956 Topics
7,338 Replies

When you subscribe we will email you when there is a new topic in this category

1956 Topics

Recently active

Most replies Most views Newest first

FrancesPantelidakis24Jr Varsity II

asked in Distribution

Account Summary Customization for Screen GL401000

Hi,I tried to customize the Account Summary screen (GL401000) by adding an extra financial period field to the header without success. I want to add a period to and from field so I can run the Account Summary by a date range versus one period. What is the correct way to add this customized field or it cannot be done without a change to the code? Let me know. I tried to publish multiple customizations but it failed each time. Here is the screen shot. I want to add another Period Field. Let me know.

2 years ago

jyounesJr Varsity II

asked in Distribution

Production Supply prepared issue

How would I go about fixing this?

2 years ago

scottaisd00Freshman I

asked in Distribution

Big Commerce Images Sync

Can Images in Acumatica/Big Commerce sync both ways? Currently if we delete an image in Acumatica, it does not delete the image from Big Commerce. Is this a setting that we can change?

2 years ago

olievesFreshman I

asked in Distribution

Cannot open record for editing. The form CA202000 does not contain it

Hello.I am trying to add the Cash Accounts Profile to a new role.I copied the AP Admin role to a new role.In the Access by Role, I granted the Banking menuI login as a user with this roleI click on Cash Account option and I see the cash accounts in screen CA2020PL. So far so goodHowever, when I click on the cash account I get the message:Cannot open record for editing. The form CA202000 does not contain itI can’t figure out what I am missing.We do not have branches, one single company Your help is appreciated

2 years ago

mrivera67Freshman I

asked in Distribution

how to update unit cost manually

hello everyone! can someone show me how to update unit cost manually for an inventory item? thanks in advance,mrivera67

2 years ago

hemalathab13Freshman I

asked in Distribution

How to Create Custom entity in Big commerce stores screen?

Hi I want to add Custom entity as “Customer Contacts” in Acumatica Big commerce stores screenplease refer below screenshot

2 years ago

shmaryarichlerFreshman II

asked in Distribution

Question about Landed Cost adjustment

If we create a sales order with a cost of 11.00 and subsequently we create a landed cost adjustment that adjusts the cost to 11.50 is any sales order with that updated with the new cost? What if we’ve created a shipment for the item. Will the system adjust the cost if a landed cost adjustment is made after the shipment. I would imagine that once it’s invoiced the cost adjustment will not affect it. So, my question is at what point will a landed cost adjustment affect the cost of the item as related to a sale of that item.Thanks

2 years ago

JacobFreshman II

asked in Distribution

Understanding the Credit Flow

Having a bit of confusion trying to understand the credit flow and how to map some of our current processes to it. The Acumatica Documentation seems to be oriented to credits only occurring Post Invoice and my confusion is how to handle situations where the invoice is not yet in place. For exampleCustomer places order on our website. Full capture occurs at the time of order. Order is injected into Acumatica with payment / transaction details attached. Shipment is created from the order and sent to the warehouse. Customer calls in “Oh, I forgot to apply my promo code. Give me 10% off”Assuming the transaction has already settled, how do I give them their discount and how does this get reflected on the order so that, if they return an item on the order, they get the correct refund? Tangentially, if I’m at the Sales Invoice, there doesn’t appear to be anyway to create a Return / RMA from that screen. Is there a better workflow than creating a new SO of the appropriate type, choosing t

2 years ago

karthikn61Freshman I

asked in Distribution

How can we configre the Multilevel Discounts with Reduced Discountable Amount at each Level - Max 4 Levels

Hi, Has anyone configured the Multi level Discounts in Acumatica using Discount Codes?I was able to achieve the followingItem Level Discounts Sub Total 1 - By defining a Discount Code - Type = Group Sub Total 2 - By defining a Discount Code - Type = Document Sub Total 3 - Not able to By defining a Discount Code - Type = Document / Group as it is taking the same Sub total of level 1 or 2.How can we achieve this?Any Idea will help Thanks,

2 years ago

scottaisd00Freshman I

asked in Distribution

Show Outstanding Balance On Invoices

Currently, when we print, email or export our Sales Invoices, they only show the original Total. How can we have our Sales Invoices show the Outstanding Balance?

2 years ago

Mondeddula Madhu Venkat ReddyJr Varsity II

asked in Distribution

when i am assigning to add transfer order in Purchsae recipt its not showing any transfer orders.

Transfer order also completed and i updated it after conforming shipment

2 years ago

asix02Freshman I

asked in Distribution

Most recent data import templates

Hi:Is there a list of data import templates, that import all data (all detail tab data) for entities (vendors, vendor items, customers, ...)?This must exist since so many people import data. I was surprised that the data provider doesn’t have a template for importing stock items. Hopefully the Acumatica Support group can provide this. Please provide them in this community portal. ThanksToon SixASix@inteltech.com

2 years ago

abdiJr Varsity III

asked in Distribution

Proccess Shipment flag already update in

Acumatica Cloud ERP 2021 R2how to in screen process shipment to give a flag if the shipment has been updated in (true / false), when action to prepare invoices di screen process shipment?so we can filter data for action prepare invoices only “false” or not yet upadate in

2 years ago

dlhr3birth73Freshman I

asked in Distribution

Inventory Transaction History Inquiry Screen not sorting properly

Hey all, looking for any sort of advice on this issue! On the Inventory Transaction History Screen (IN405000) after entering the Inventory ID my results have one line that is out of order by date. Sort Ascending works to get the lines in the correct order but I am curios if there is a way to have it Sort Ascending by default. Another thing worth noting is that whenever the Include Unreleased checkbox in the summary area is select it also fixes the sorting issue, thanks!

2 years ago

jay13Freshman I

asked in Distribution

IS THERE A WAY TO ENLONG INVENTORY ID? (more than 30)

Hi,I have some items which the supplier part number is more than 30 characters.Our current setting is to put it under attribute, the issue with this it is not searchable when issuing Purchase Order.So I want to move it to cross reference, then it comes this question, the limitation of cross reference length can be extended ?

2 years ago

NAWRESJr Varsity II

asked in Distribution

Default Shipping Rule

Hello Guys :) When we create a new business account, the Shipping Rule (Delivery Settings) defaults to Cancel Remainder. Is there a way to set the default shipping rule to Back Order Allowed for Business Accounts like we do for customer (through family class) ? Thnx :)

2 years ago

meagan59

asked in Distribution

Stock Item base UOM won't update

When we try to update the Base Unit from CS to EA, the setting just returns to CS without an error. What may be causing the issue? Are there other item settings that stop the user from changing the Base Unit?There is no current stock for the item and no open transactions in the system.

2 years ago

byates

asked in Distribution

SO Shipments moving inventory in transit

Hello, apologies for the long question.I am working to setup Acumatica and noticed the handling of inventory for Sales Order shipments is different than every system I have worked on in the past. With our current configuration, when you create shipment for a Sales order you stop just short of Updating IN. This is because one you Update IN it creates the inventory COGS transaction on the PL. We do not invoice and recognize the revenue, until the product is delivered to our customers. So if you do Update IN this creates a disconnect between revenue and expense (not an option). However, if you do not Update IN the inventory remains “On Hand” at the warehouse and all reporting shows those quantities on hand. What I would prefer to see is that inventory moved to In Transit until the SO is invoices at which time the inventory is expenses and the Receivable is created. Due to the inventory remaining ON Hand I am having a difficult time reconciling physical counts at our sites and creates a hu

2 years ago

matt87Freshman I

asked in Distribution

Add Shipping and Handling Charge to Sales Orders

My company adds $3.75 handling fee to outbound UPS shipments. This amount is added to the freight cost we incur from the carrier (UPS), the sum of the two quantities (freight cost + our handling fee) are combined and billed to the customer on their invoice. I see handling charges can be added using SHIPPING TERMS, which can be assigned within CUSTOMER CLASSES. However, if I have a sale that is delivered via my company’s truck or if the customer picks up at my facility there should not be a shipping and handling charge. I’d like to avoid relying on users to manually change the SHIPPING TERMS on a sales order each time there is a customer pickup or deliver via our truck. Is there a way to attach the shipping and handling charge to SHIP VIA or CARRIER so this is automated? There must be something I’m missing in order to accomplish this. We are not the only company to use freight padding.Thank you,Matt

2 years ago

ray20Captain II

asked in Distribution

Can IN issues which be generated by Credit memo having original cost on customer return items

Hello, I met a case, user miss put 66.2 cases line item on invoice, which should be 66.2 lb. The “real” shipment is 66.2 lb. And AR total is correct. So it is just system document typo error. Then I manually created a credit memo, which is to get 66.2 cases back(virtually) and issue 66.2 lb. Then I found out the IN issues based on this credit memo is automatically released. However, the cost of the returned 66.2 cases is 0. Which I’d like to be the same cost as the sold items. Such as $6 per cases. It might be my mistake, that I just added the credit memo lines manually. I am not sure, if I used the “add return line” function, whether the cost would be input as I expected. But sometimes it is the quickest way to do it, and users are preferring using this way (add lines directly), because it is quick. If I would like the customer return at original cost, what is the best way to do it?

2 years ago

alicezyks51Semi-Pro II

asked in Distribution

Inventory Summary out of balance versus PO Lines

The quantity open on PO per the inventory summary is overstated. One PO (PO001122) line is duplicated in the summary and the MRP detail inquiry, but is correct on the PO line inquiry and the actual PO. The promised date was changed for a couple items on this PO (supply chain issues) but only one line is being duplicated.We have run “Recalculate Inventory” and the error did not resolve. Also tried editing both the PO and the line but the duplicate is not clearing. Below are screen prints showing the discrepancy:We’re at a loss to figure out why this discrepancy occurred and how to resolve it. Any thoughts or suggestions would be appreciated. Thanks!

2 years ago

DharmandarKumarFreshman I

asked in Distribution

Purchase Order Create time Approve Action Perform Through Rest API

In Purchase Order Create Time Approve and reject action perform through Rest ApiI can’t Find action To perform approve purchase Order

2 years ago

MichaelhSemi-Pro II

asked in Distribution

Block Items not allocated to the PO Vendor

Every Purchase Order requires a Vendor. Every Item has a Vendor attached to it. How do I tell a PO to only allow line items who are set for the vendor on the PO? Example: I am buying from Bob on a PO, but Acumatica lets me try to buy an item that is only sold by Frank. If a PO is for Bob, why can’t the item selector only show me items buyable from Bob? I don’t care about the things I can buy from Frank. This would also help ensure that the vendors are attached properly (like Bob sells Milk, but I don’t see Milk on my list, so I know something is off on the item). Hopefully this is a toggle somewhere I’m missing.

2 years ago

JacobFreshman II

asked in Distribution

How to prevent an Item from being dropshipped?

We work with hundreds of vendors, some with whom we can drop-ship and some we cannot. Is there a mechanism by which we can prevent a user from creating a drop-ship PO on a certain items or with certain vendors?

2 years ago

classiter

asked in Distribution

Confirming Shipment / Grabbing Labels from USPS takes way too long

We are trying to wave and batch pick thousands of shipments per day. The system will not allow us to print the labels until the shipments are confirmed, so we have a business event running that will autoconfirm the shipments after they have been picked. This allows the picker to print the labels and packing slips directly after they have picked. The issue is the confirmation takes 30-45 seconds or more per shipment. so if we are batch picking 25 orders with the same product on them, it takes 10 minutes until the labels can be printed. There has to be something we are missing here - confirming a single shipment manually only takes a couple of seconds. We are using out of the box Stamps.com integration.

2 years ago

Page 57 / 79

Badge winners

tarashas earned the badge Easy talker
hkabirihas earned the badge Import and Export Scenario expert
aiwanhas earned the badge Acumatica expert
rfrantzhas earned the badge Easy talker
WillHhas earned the badge Easy talker

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Social Login

Login to the community

Social Login

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.