Learn
Learn
Support
Support
Product
Community
Partners

Community
Discussion ForumsFinancials 604 Distribution 690 Manufacturing201 Construction207 Property Management9 Field Service94 Retail-Commerce180 Payroll85 Configuration and Installation 285 Reports and Generic Inquires 477 Integrations and ISV Solutions 298 Import and Export Scenarios 208 System Health and Performance 44 Community site discussions72 Community Introductions23 Everything Else 316
DevelopersDeveloper News & Announcements13 Customizations851 xRP Framework2 Web Services | APIs25 Mobile Development12 Miscellaneous Developer Topics17
News & AnnouncementsAcumatica News & Updates50 Developer Newsletter 11 Newsletter 13

Create topic
Login

Community
Search

Replies posted by dgodsill97

59 Replies

Newest first

Oldest first

dgodsill97Jr Varsity III

asked in Distribution

How to default sales/cogs account and sub based on reason codes

The problem with that is every line must have a reason code.

1 month ago

brendan91Jr Varsity III

asked in Retail-Commerce

Export Price Class to Shopify

Yes, that’s the problem; the client is using Sales Prices and wants to send the Base Sales Price to Shopify instead of the stock item default price. So the only solution would be to update the Stock Item on a change of the base sales price.

4 months ago

brendan91Jr Varsity III

asked in Retail-Commerce

Export Price Class to Shopify

Is the connector for Shopify using Generic Inquires as the data source for synchronization? If so, could we modify the GI to pull in the sales price from ARSalePrice?

4 months ago

dgodsill97Jr Varsity III

asked in Distribution

How to default sales/cogs account and sub based on reason codes

No, the client sells parts and the same part could be sold for free because it is under warranty. When sold for warranty, the expense needs to go to a different COGS account/subaccount.

1 month ago

KurtBauerJr Varsity II

asked in Retail-Commerce

Big Commerce sales price sync with wrong unit of measure (UOM)

Yes, I did mean sales UOM. The customer is live on 2021R2 and needs to get commerce going ASAP per their CEO. They have fittings stocked in EA but need to sell in packages of 25 in Big Commerce.Thanks for your help. When can the customization be ready?

4 months ago

KurtBauerJr Varsity II

asked in Retail-Commerce

Big Commerce sales price sync with wrong unit of measure (UOM)

Yes, it complies but fails to publish on my 2021R2. I can’t upgrade the customer to an unreleased version.

4 months ago

KurtBauerJr Varsity II

asked in Retail-Commerce

Big Commerce sales price sync with wrong unit of measure (UOM)

Is there a version of the customization for 2021R2? My client needs to sell the product on BC using the Stock UOM. Apparently BC does not have a concept of units of measure.

4 months ago

dgodsill97Jr Varsity III

asked in Retail-Commerce

Changing the Availalbilty setting for Big Commerce to exclude negative available

For this client, each customer is fulfilled by a regional warehouse using client trucks to deliver the goods. So if you are a AZ customer on the Thursday route your orders are fulfilled by the AZ warehouse and delivered by client truck. How difficult is it to customize the connector to allow export mapping and/or filtering for the Product Availability? Export mapping would the ideal situation because you can write a formula to change the stock level in BC. We often find that clients want to manipulate the stock level they show to customers - very common when sending the EDI 846 to a trading partner.

3 months ago

dgodsill97Jr Varsity III

asked in Retail-Commerce

Changing the Availalbilty setting for Big Commerce to exclude negative available

Same example but allocating the sale order. This is better and may work for the client.

3 months ago

dgodsill97Jr Varsity III

asked in Retail-Commerce

Changing the Availalbilty setting for Big Commerce to exclude negative available

Sorry, it keeps throwing away the screen shot.

3 months ago

dgodsill97Jr Varsity III

asked in Retail-Commerce

Changing the Availalbilty setting for Big Commerce to exclude negative available

This is an example I set up and tested with the store setting for Availability Mode for Available and Available for Shipping. According to the client, the available calc should be 10 for there are 10 units available in WHOLESALE.When set to Available the store shows a qty of 8 When set to Available for Shipping it shows 20

3 months ago

dgodsill97Jr Varsity III

asked in Retail-Commerce

Changing the Availalbilty setting for Big Commerce to exclude negative available

They have multiple warehouse and the negative availability in one warehouse should be ignored. BC currently cannot show available by warehouse.

3 months ago

dgodsill97Jr Varsity III

asked in Distribution

Confirming purcase orders wtih vendors

That relies on users. The ideal solution would require the supplier to confirm the PO and that action update the PO to how that the supplier confirmed. Something like confirming a recipient read an email and replied. Or something like DocuSign. We will look at Source Day.

3 months ago

dennisgodsill36Jr Varsity III

posted in Integrations and ISV Solutions

Has anyone done an integration/conection to BarTender label printing software?

A customer mentioned the Enterprise Edition of Bar Tender has API’s that can be used to integrate with Acumatica. https://www.seagullscientific.com/solutions/integrations-and-technology/erp-and-business-systems/ https://www.seagullscientific.com/solutions/integrations-and-technology/integrations-with-bartender/

5 months ago

vpanchenkoTeam Lead, Reporting&Core

posted in Configuration and Installation

Deprecate Wiki Access Rights to simplify things

I use the Wikis as part of training so user know where to find the how to information. Having open access to the standard wiki is a good idea. As a former ISV who had to create and maintain our product’s wiki, having to fix access rights was a waste of time. So you need to extend the open access to all ISV wikis but you could make this an option on the Wiki for those clients who wish restrict access.

7 months ago

ltussing03Varsity I

asked in Manufacturing

MRP Display says we need to order, we do not need to order, we only need to expedite an existing PO

MRP is trying to balance supply and demand. The Grace days in MRP controls whether or not it generates a new planned order to cover demand or use existing supply. If supply is withing grace days and outside of the Days Late you get a expedite message. These are the only 2 options to balance supply to demand. The alternative to balance demand to the supply by changing the demand date. If the demand is only safety stock then reduce the safety stock, If there are other demands, then change the promise date of the demand if sales demand, or the start date of production orders if for production.Generally, my preference is to review the exceptions message first for Late and Expedite messages because they have the most impact.

7 months ago

KarthikGajendranSemi-Pro III

posted in Retail-Commerce

How-To: Handle product availability when the Warehouse-Location mapping is changed for already exported location

Big Commerce. I have heard that Shipper HQ handles this. Any comments?https://docs.shipperhq.com/setup-multiorigin-dropshipping/

7 months ago

KarthikGajendranSemi-Pro III

posted in Retail-Commerce

How-To: Handle product availability when the Warehouse-Location mapping is changed for already exported location

How can you show inventory availability based on the warehouse assigned to the customer? Client has regional warehouses and for B2B only wants to show inventory availability for the warehouse assigned to the customer. For B2C they would like to show inventory only for the warehouse closest to the customer.

7 months ago

MaracujaFreshman II

asked in Manufacturing

How is a product configurator item considered in MRP (e.g. for safety stock)?

Are you a partner or an end user and where are you located? If you are a partner, then Acumatica can assist; for an end user, your partner can assist. A planning bill is not different than any other bill. As long as decimals are allowed for quantities you can enter a % as .2 for 20% etc. All the make planning bill does is update the default planning bill id on the Stock Item and/or Item Warehouse Details. MRP automatically uses the default planning bill if present and if not the default bill from the Item Warehouse Details.You would have to ask Acumatica about attribute on lot/serial records. The GITHUB package has been used by multiple customers.

7 months ago

zoeymuffJr Varsity II

asked in Manufacturing

reviewing labor ticket for a period of time with production ticket number field

This article details the manufacturing tables. You woull want to use the data in AMMTran.https://help-2021r2.acumatica.com/Help?ScreenId=ShowWiki&pageid=1ce567e9-7d64-4f0d-aa14-d894a35a8fc3

7 months ago

MaracujaFreshman II

asked in Manufacturing

How is a product configurator item considered in MRP (e.g. for safety stock)?

For configure to order items it is common to use a planning bill of material which specifies all of the standard parts as well as the percentage of each option expected to be selected. For example, feature A has 3 options O1, O2, and O3. 50% of of the customer order Q1, 30% O2, and 20% O3. Periodically, you would revise these percentages based on the ordering pattern. As far as stocking configured products, assuming you are using lot/serial tracking, you would need to store the configuration results id somewhere when the unit is being received into stock so the unit could be identified later. There is a GITHUB package that allows the entry of attributes for the lot/serial number. Each configuration results ID (multiple tables) have the link to the sales and production ID’s.

7 months ago

dgodsill97Jr Varsity III

asked in Financials

How to get the financial period name in an ARM Report

It does not support the shift option like =Report.FormatPeriod(@StartPeriod,-4)

5 months ago

dgodsill97Jr Varsity III

asked in Financials

How to get the financial period name in an ARM Report

Thanks, should have more examples like this is help, manuals, and training courses.

5 months ago

zoeymuffJr Varsity II

asked in Distribution

PUCHASE ODER LINE WITH MULTIPLE SHIPPING DATES AND QTY

No, you just have to modify the form to add POLine.LineNbr to the POLine group in Report Designer.

9 months ago

zoeymuffJr Varsity II

asked in Distribution

PUCHASE ODER LINE WITH MULTIPLE SHIPPING DATES AND QTY

You have to enter a line on the PO for each requested ship date. To see the dates on the printed PO form you have to add LineNbr to the grouping for the PO form as well as add a column for the line requested date.

9 months ago

Page 2 / 3

Badge winners

FarhanaM60has earned the badge Easy talker
Harshitahas earned the badge Easy talker
rbrownNAWhas earned the badge Easy talker
Debbie Baldwinhas earned the badge Acumatica Expert
gprice27has 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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

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.

About Acumatica ERP system

Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.

Privacy Policy
Terms of Use
GDPR
SLA
Support
Report an Outage