Where my discounts are going?

[cparralesl]

Hello guys,

I'm so worried about an apparently issue that Macola seems to have with discounts.

We are using the code price option, this oviously can be understood as discount to the customers or a price reduction. Any way you got it, this create a diference between the original price and the new reduced price. This is a big problem because since we install Macola, two or three years ago, we had not found in what account or where this amount is placed. I think this should be booked in some where but i do not know it.

I know where the discount is going when it is set from the Customer Master option, this is consider as special discount for us and we know that this amount is booked in the account set in the AR module setup.

What happen with the others discounts?

Where they are gone?


I will thank any help about it.

Cesar Humberto Parrales
Application Support

 

[dgillz]

Under Macola 7x, there is no entry made for any of these types discounts. For example $100 line item with 10% discount is a $90 sale, and you get a $90 Debit to AR and a $90 Credit to revenue with no entry for $10 taking place.

The only discount that gets an entry made is an early payments discount such as 1% 10 Net 30. You get a 1% discount which is recognized at the time the invoice is PAID, not posted. The account this goes to is controlled by the customer type associated with the customer on the order.

Under Macola ES you have an option to journalize the Gross and Net sales, creating a 3 line distribution, $90 debit to AR, $10 debit to a discount account and a $100 credit to a revenue account.

I hope this helps.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[stravis]

If you desire, I have a customization for Macola that can apply whole order discounts and charges for an order. These discounts are added as a line item to an actual order. With this application you define default and optional discounts/charges for a customer and then these discount/charges can be added to a order either through manual order entry or through a stand-alone utility.

With this application you can track your discounts as you desire. It does not currently work with individual line item discounts, but the program could be expanded to provide for this. Please email me if you are interested. We will work with your existing Macola/Exact Business Partner to implement this.

Scott Travis
scott@ nexosystems.com (remove the space to email)

 

[MacolaHelp]

I think you programming gurus should start a list of VBA/Flex apps you have done & have available for others to buy/modify/get for free, whatever. It's great to hear what you've got out there as I'm always getting one request or another that it seems a VB app could/should/would address. A list of what you've done w/a brief explanation & I could figure out if I could get in touch w/you to slightly modify, etc.

 

[cparralesl]

Thanks guys,

Don:

So Macola dos not make any accounting transaccion to register this discount? The automatic discount generated from the code price option is not sent to any where even to G/L? if so, This is a completly mess, because even though we need the net sale at the end, this informations is necesary in order to guide us in our discount policies and also this is information should be booked in G/L in it account. Wow!.

Travis:

The advantage of this option is that the discount is given according to the Price Code Types sequence when the invoice or order is in process and this work just fine, so i'm not clear if your customization can deal with this? Beside, I'm not clear if this can handle this discount in G/L. I would like to see your App working. You can send it at cesar.parrales@kraftla.com


Thanks again guys,

Cesar Humberto Parrales
Application Support

 

[dgillz]

Scott,

does your program create the records in the ARDISFIL for the distribution amounts?

Don Gilsdorf

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[MacolaHelp]

Macola has always netted the sale less discount into the unit price, extended price & the distribution files.

If you need to capture this info, you'll need to write a crystal report or do an excel/msquery to capture the amount of the discount to report & create a journal entry. Have you tried either of these tools? You are just not going to get a tracking mechanism in generic Macola to report the way you want. HOWEVER, since the data is stored in the files you can get it back.

Ask for help from your Macola VAR or one of us can probably help you get started.

 

[cparralesl]

MacolaHelp:

Of course we have been solve this situation using reports, ERS5 in my case because crystal goes too slow down. But my ponit is that how it can be possible? You make a discount in Macola, using feature/optiong given from themselves, and this amount is not registered in any account into OE module nor GL module neither. >:-<

This information can be obtained, of course, with reports tools, but from any points of view, you can not see your discount given to your customers in GL directly because this is not saved there. :-(

Thanks again guys, and i appreciate all your comments'

Cesar Humberto Parrales
Application Support

 

[dgillz]

Humberto,

I do not know about your part of the world, but in the USA, it is not necessary to make a GL entry to record the discount in the manner discussed.

I think it is a good thing to have the ability to do - I would love to show discounts as contra-revenue accounts. I am glad Macola ES gives you this flexibility, but it is not required.

I think some VBA/Flex code to change the existing ARDISFIL records (to show gross revenue) and add an addtional line (to show discounts) would be fairly straight forward, but there are better people on this forum to address that than me.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[MacolaHelp]

Seems like we all agree that we should be able to track list price & discount at the order line level as well as the GL. Unfortunately, no generic macola 7.6 programs do this, so you must use custom reports.

It sounds, Humberto, like you are a candidate to migrate to ES if you want the generic macola code to do this. So, you can venture into these waters, or be content with the reports you've written. I guarantee that if macola has addressed your issues in a revision that you haven't implemented, that you will have no luck persuading them to modify the 7.6.100 code to perform as the current release.

Just a reality check. If you can't work around what bugs you today & you don't want to upgrade, you are stuck. Or, you can move to the &quot;bleeding edge&quot; of a cr/almost GR product.

 

[dgillz]

Actually Macola ES went GR on June 1. The conversion utility is still in controlled release, however.

I tire of the constant posts about Macola ES not being &quot;ready&quot;. While there is some truth in this, I would not be afraid to go to ES. I have one client using ES with few problems, and I have been running my own business on ES for 10 months.

One of the problems with ES is that both resellers and users seem to be afraid of going there, but lets face it, the only way the product will ever be &quot;ready&quot; is for a number of people to start using it.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[MacolaHelp]

As of the conference call last Thursday, the Macola execs are indicating that new sites using ES are going pretty well, but that conversion sites are struggling because the conversion utility isn't ready for prime time. That seems to be the theme and general wisdom on this forum as well. There were conversion issues going from v6 to v7 as well, so I am not surprised.

Unless a current user is prepared to clean up converted data or rekey or start over as a new install & use their progression for history, they will indeed be on the bleeding edge of this product. The financials are vastly different from progression, so it's really like learning a new product. If a current user really wants to move to ES now, they need to do a thorough test conversion & pilot, identifying data cleanup and training issues before going live.

My clients are so busy struggling with the economic climate, reduced staff & overwork that they have no energy to take on a project of this magnitude. Unless there is a compelling reason to move to ES, most of my clients are going to try to optimize their current installation until they have more internal resources to devote to an upgrade. Although some resellers and users may be afraid, there are some of us that have not had great experiences with early release products. Managing client expectations is the key to a successful implementation & we only get that if the client can see a benefit to all this extra work, expense, and disruption to the normal business workflow.