How to keep track of discounts in GP?

[lguifarro]

Hello:

We are having problems keeping track of discounts in GL. This is the scenario:

When a SOP is issued, in order to calculate the price, we do the following:
we have a X-item the base list price listed as $100, but this price list,
the base one, is only use as a referral to other price lists that we have. So
if there's a price list for Supermarkets called, "SUPER A", and the client is
a supermarket obviously, this same X-item appears with a 90% of the price,
meaning that it's actual price is $90, but if there's another price list for
a special offer or sales, we have another list price called " ONSALE B", and
this X-Item is listed as 80% of the price, so that would be $80, so in theory
the sales price is 80% and you can say a $20 discount was given to the
customer.

Here is when things get weird, to my mind there was a discount given to the
customer for $20 but as usual GP disagrees with me(damned you GP, i know
best, LOL), in the accounts distributions, when I check the account for
discounts, is in zero, meaning that GP does not considered the $20 as a
discount but something else. And you can guess the type of havoc this has
caused in accounting.

I don't know if what we are doing so far, with the many price list, is right
or wrong but in order to solve my current situation I tought of a possible
way to do this. As far as i know, the only discount that GP treats as
discount perse, is the one you type individually for each item in a line of a
SOP, then in the discount window were you specified ,either a percentage or
an amount, it's reduced from the price and there you go. So is there a way
to populate this in a form somewhere in GP, the "markdown entry window", or
something so i'll specify the discount percent for each item, and in the case
when the customer got a special discount set priorities, where first check
the customer then the offers and then the item, or something similar, please
let me know.

Any help is appreciated

Regards

Luis

[lguifarro]

I meant price sheets not price lists, so it's price sheets, sorry

Regards

Luis

Post by lguifarro
we have a X-item the base list price listed as $100, but this price list,
the base one, is only use as a referral to other price lists that we have. So
if there's a price list for Supermarkets called, "SUPER A", and the client is
a supermarket obviously, this same X-item appears with a 90% of the price,
meaning that it's actual price is $90, but if there's another price list for
a special offer or sales, we have another list price called " ONSALE B", and
this X-Item is listed as 80% of the price, so that would be $80, so in theory
the sales price is 80% and you can say a $20 discount was given to the
customer.
Here is when things get weird, to my mind there was a discount given to the
customer for $20 but as usual GP disagrees with me(damned you GP, i know
best, LOL), in the accounts distributions, when I check the account for
discounts, is in zero, meaning that GP does not considered the $20 as a
discount but something else. And you can guess the type of havoc this has
caused in accounting.
I don't know if what we are doing so far, with the many price list, is right
or wrong but in order to solve my current situation I tought of a possible
way to do this. As far as i know, the only discount that GP treats as
discount perse, is the one you type individually for each item in a line of a
SOP, then in the discount window were you specified ,either a percentage or
an amount, it's reduced from the price and there you go. So is there a way
to populate this in a form somewhere in GP, the "markdown entry window", or
something so i'll specify the discount percent for each item, and in the case
when the customer got a special discount set priorities, where first check
the customer then the offers and then the item, or something similar, please
let me know.
Any help is appreciated
Regards
Luis

...

[Janakiram]

Dear Luis

There are two ways of doing this.

1. You can look at the Extended Pricing feature which gives you the
option of choosing multiple complex price lists and primarily handles
your promotion stuff much much better
2. You can also look at doing a out of the box VB customization which
can be enabled on each item price list window which can then propulate
the markdown automatically in SOP entry. We have done this for one of
our clients.

Thanks

Janakiram M.P.

Post by lguifarro
I meant price sheets not price lists, so it's price sheets, sorry
Regards
Luis

Post by lguifarro
we have a X-item the base list price listed as $100, but this price list,
the base one, is only use as a referral to other price lists that we have. So
if there's a price list for Supermarkets called, "SUPER A", and the client is
a supermarket obviously, this same X-item appears with a 90% of the price,
meaning that it's actual price is $90, but if there's another price list for
a special offer or sales, we have another list price called " ONSALE B", and
this X-Item is listed as 80% of the price, so that would be $80, so in theory
the sales price is 80% and you can say a $20 discount was given to the
customer.
Here is when things get weird, to my mind there was a discount given to the
customer for $20 but as usual GP disagrees with me(damned you GP, i know
best, LOL), in the accounts distributions, when I check the account for
discounts, is in zero, meaning that GP does not considered the $20 as a
discount but something else. And you can guess the type of havoc this has
caused in accounting.
I don't know if what we are doing so far, with the many price list, is right
or wrong but in order to solve my current situation I tought of a possible
way to do this. As far as i know, the only discount that GP treats as
discount perse, is the one you type individually for each item in a line of a
SOP, then in the discount window were you specified ,either a percentage or
an amount, it's reduced  from the price and there you go. So is there a way
to populate this in a form somewhere in GP, the "markdown entry window", or
something so i'll specify the discount percent for each item, and in the case
when the customer got a special discount set priorities, where first check
the customer then the offers and then the item, or something similar, please
let me know.
Any help is appreciated
Regards
Luis- Hide quoted text -

- Show quoted text -

...

[lguifarro]

Thanks for the reply:

Where do i exactly look at this Extended Price that you mentioned bacause i
haven't been able to find it.

Regards

Luis

Post by Janakiram
Dear Luis
There are two ways of doing this.
1. You can look at the Extended Pricing feature which gives you the
option of choosing multiple complex price lists and primarily handles
your promotion stuff much much better
2. You can also look at doing a out of the box VB customization which
can be enabled on each item price list window which can then propulate
the markdown automatically in SOP entry. We have done this for one of
our clients.
Thanks
Janakiram M.P.

Post by lguifarro
I meant price sheets not price lists, so it's price sheets, sorry
Regards
Luis

Post by lguifarro
we have a X-item the base list price listed as $100, but this price list,
the base one, is only use as a referral to other price lists that we have. So
if there's a price list for Supermarkets called, "SUPER A", and the client is
a supermarket obviously, this same X-item appears with a 90% of the price,
meaning that it's actual price is $90, but if there's another price list for
a special offer or sales, we have another list price called " ONSALE B", and
this X-Item is listed as 80% of the price, so that would be $80, so in theory
the sales price is 80% and you can say a $20 discount was given to the
customer.
Here is when things get weird, to my mind there was a discount given to the
customer for $20 but as usual GP disagrees with me(damned you GP, i know
best, LOL), in the accounts distributions, when I check the account for
discounts, is in zero, meaning that GP does not considered the $20 as a
discount but something else. And you can guess the type of havoc this has
caused in accounting.
I don't know if what we are doing so far, with the many price list, is right
or wrong but in order to solve my current situation I tought of a possible
way to do this. As far as i know, the only discount that GP treats as
discount perse, is the one you type individually for each item in a line of a
SOP, then in the discount window were you specified ,either a percentage or
an amount, it's reduced from the price and there you go. So is there a way
to populate this in a form somewhere in GP, the "markdown entry window", or
something so i'll specify the discount percent for each item, and in the case
when the customer got a special discount set priorities, where first check
the customer then the offers and then the item, or something similar, please
let me know.
Any help is appreciated
Regards
Luis- Hide quoted text -

- Show quoted text -

...

[Janakiram]

Dear Luis

You should be able to enable extended pricing by going to Microsoft
Dynamics GP>Tools>Setup>Sales>Extended Pricing and then enable
Extended Pricing. If you see that Enable extended pricing is greyed
out, it means you dont have license. Please check the partnersource on
how to obtain extended pricing and check the features before you make
a decision.

On the VBA customization side, You should do it on Item Price List
screen.

Thanks

Janakiram M.P.

Post by lguifarro
Where do i exactly look at this Extended Price that you mentioned bacause i
haven't been able to find it.
Regards
Luis

Post by Janakiram
Dear Luis
There are two ways of doing this.
1. You can look at the Extended Pricing feature which gives you the
option of choosing multiple complex price lists and primarily handles
your promotion stuff much much better
2. You can also look at doing a out of the box VB customization which
can be enabled on each item price list window which can then propulate
the markdown automatically in SOP entry. We have done this for one of
our clients.
Thanks
Janakiram M.P.

Post by lguifarro
I meant price sheets not price lists, so it's price sheets, sorry
Regards
Luis

Post by lguifarro
we have a X-item the base list price listed as $100, but this price list,
the base one, is only use as a referral to other price lists that we have. So
if there's a price list for Supermarkets called, "SUPER A", and the client is
a supermarket obviously, this same X-item appears with a 90% of the price,
meaning that it's actual price is $90, but if there's another price list for
a special offer or sales, we have another list price called " ONSALE B", and
this X-Item is listed as 80% of the price, so that would be $80, so in theory
the sales price is 80% and you can say a $20 discount was given to the
customer.
Here is when things get weird, to my mind there was a discount given to the
customer for $20 but as usual GP disagrees with me(damned you GP, i know
best, LOL), in the accounts distributions, when I check the account for
discounts, is in zero, meaning that GP does not considered the $20 as a
discount but something else. And you can guess the type of havoc this has
caused in accounting.
I don't know if what we are doing so far, with the many price list, is right
or wrong but in order to solve my current situation I tought of a possible
way to do this. As far as i know, the only discount that GP treats as
discount perse, is the one you type individually for each item in a line of a
SOP, then in the discount window were you specified ,either a percentage or
an amount, it's reduced  from the price and there you go. So is there a way
to populate this in a form somewhere in GP, the "markdown entry window", or
something so i'll specify the discount percent for each item, and in the case
when the customer got a special discount set priorities, where first check
the customer then the offers and then the item, or something similar, please
let me know.
Any help is appreciated
Regards
Luis- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

...

[Victoria [MVP]]

Luis,

You're right, if the price list reflects the 'discounted' price, there is
nowhere in GP that it keeps track of the discount. The markdown
accomplishes what you want by creating a separate GL distribution for the
discount, but out-of-the-box you have to populate that manually.

One other option I have used, if the discount doesn't need to be tracked in
different GL accounts depending on item, is Trade Discount. For example,
you know that Customers in class SUPERMARKET always get 10% off. Enter the
trade discount on the Customer Card (or enter it on the class and roll it
down, if you are using classes). When you enter an SOP transaction, the
trade discount will be calculated automatically. If there is a special in
place, and you want to show that separately, you can still enter an
additional markdown, but that should now be an exception.

The trade discount actually gets calculated by line item in the SOP tables,
so if you need to show this by line item on invoices, you can - of course
you would need to customize your report(s) for this. Otherwise, if you are
ok showing the discount as a total at the end, GP will do that
automatically.
--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions - home of GP Reports
http://www.flex-solutions.com/gpreports.html
blog: http://www.victoriayudin.com

Post by lguifarro
we have a X-item the base list price listed as $100, but this price list,
the base one, is only use as a referral to other price lists that we have. So
if there's a price list for Supermarkets called, "SUPER A", and the client is
a supermarket obviously, this same X-item appears with a 90% of the price,
meaning that it's actual price is $90, but if there's another price list for
a special offer or sales, we have another list price called " ONSALE B", and
this X-Item is listed as 80% of the price, so that would be $80, so in theory
the sales price is 80% and you can say a $20 discount was given to the
customer.
Here is when things get weird, to my mind there was a discount given to the
customer for $20 but as usual GP disagrees with me(damned you GP, i know
best, LOL), in the accounts distributions, when I check the account for
discounts, is in zero, meaning that GP does not considered the $20 as a
discount but something else. And you can guess the type of havoc this has
caused in accounting.
I don't know if what we are doing so far, with the many price list, is right
or wrong but in order to solve my current situation I tought of a possible
way to do this. As far as i know, the only discount that GP treats as
discount perse, is the one you type individually for each item in a line of a
SOP, then in the discount window were you specified ,either a percentage or
an amount, it's reduced from the price and there you go. So is there a way
to populate this in a form somewhere in GP, the "markdown entry window", or
something so i'll specify the discount percent for each item, and in the case
when the customer got a special discount set priorities, where first check
the customer then the offers and then the item, or something similar, please
let me know.
Any help is appreciated
Regards
Luis

...

[lguifarro]

thanks for you reply.

The thing is that we have several accounts for discount for all the items,
for example, when we sell Johnie Walker, there's a account called, "Johnie
Walker Sales", and "Johnie Walker Discounts", and so on, for the rest of the
items. That's why i'm looking of a way to automatically populate the markdown
so when we sell this the discount automacally goes for it's respective
account. I know that in order to mantain this i'll have to do some VBA to
create perhaps a form so people can, in case it varies, mantain the proper
discounts percentages for the items.

Also where do you set the mark down for the items in GP, or the markdowns??

Regards

Luis

Post by Victoria [MVP]
Luis,
You're right, if the price list reflects the 'discounted' price, there is
nowhere in GP that it keeps track of the discount. The markdown
accomplishes what you want by creating a separate GL distribution for the
discount, but out-of-the-box you have to populate that manually.
One other option I have used, if the discount doesn't need to be tracked in
different GL accounts depending on item, is Trade Discount. For example,
you know that Customers in class SUPERMARKET always get 10% off. Enter the
trade discount on the Customer Card (or enter it on the class and roll it
down, if you are using classes). When you enter an SOP transaction, the
trade discount will be calculated automatically. If there is a special in
place, and you want to show that separately, you can still enter an
additional markdown, but that should now be an exception.
The trade discount actually gets calculated by line item in the SOP tables,
so if you need to show this by line item on invoices, you can - of course
you would need to customize your report(s) for this. Otherwise, if you are
ok showing the discount as a total at the end, GP will do that
automatically.
--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions - home of GP Reports
http://www.flex-solutions.com/gpreports.html
blog: http://www.victoriayudin.com

Post by lguifarro
we have a X-item the base list price listed as $100, but this price list,
the base one, is only use as a referral to other price lists that we have. So
if there's a price list for Supermarkets called, "SUPER A", and the client is
a supermarket obviously, this same X-item appears with a 90% of the price,
meaning that it's actual price is $90, but if there's another price list for
a special offer or sales, we have another list price called " ONSALE B", and
this X-Item is listed as 80% of the price, so that would be $80, so in theory
the sales price is 80% and you can say a $20 discount was given to the
customer.
Here is when things get weird, to my mind there was a discount given to the
customer for $20 but as usual GP disagrees with me(damned you GP, i know
best, LOL), in the accounts distributions, when I check the account for
discounts, is in zero, meaning that GP does not considered the $20 as a
discount but something else. And you can guess the type of havoc this has
caused in accounting.
I don't know if what we are doing so far, with the many price list, is right
or wrong but in order to solve my current situation I tought of a possible
way to do this. As far as i know, the only discount that GP treats as
discount perse, is the one you type individually for each item in a line of a
SOP, then in the discount window were you specified ,either a percentage or
an amount, it's reduced from the price and there you go. So is there a way
to populate this in a form somewhere in GP, the "markdown entry window", or
something so i'll specify the discount percent for each item, and in the case
when the customer got a special discount set priorities, where first check
the customer then the offers and then the item, or something similar, please
let me know.
Any help is appreciated
Regards
Luis

...

[Victoria [MVP]]

You mean where do you set the markdown GL account number? That's going to
be on the Item Account Maintenance (Cards > Inventory > Item > Accounts).
--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions - home of GP Reports
http://www.flex-solutions.com/gpreports.html
blog: http://www.victoriayudin.com

Post by lguifarro
thanks for you reply.
The thing is that we have several accounts for discount for all the items,
for example, when we sell Johnie Walker, there's a account called, "Johnie
Walker Sales", and "Johnie Walker Discounts", and so on, for the rest of the
items. That's why i'm looking of a way to automatically populate the markdown
so when we sell this the discount automacally goes for it's respective
account. I know that in order to mantain this i'll have to do some VBA to
create perhaps a form so people can, in case it varies, mantain the proper
discounts percentages for the items.
Also where do you set the mark down for the items in GP, or the markdowns??
Regards
Luis

Post by Victoria [MVP]
Luis,
You're right, if the price list reflects the 'discounted' price, there is
nowhere in GP that it keeps track of the discount. The markdown
accomplishes what you want by creating a separate GL distribution for the
discount, but out-of-the-box you have to populate that manually.
One other option I have used, if the discount doesn't need to be tracked in
different GL accounts depending on item, is Trade Discount. For example,
you know that Customers in class SUPERMARKET always get 10% off. Enter the
trade discount on the Customer Card (or enter it on the class and roll it
down, if you are using classes). When you enter an SOP transaction, the
trade discount will be calculated automatically. If there is a special in
place, and you want to show that separately, you can still enter an
additional markdown, but that should now be an exception.
The trade discount actually gets calculated by line item in the SOP tables,
so if you need to show this by line item on invoices, you can - of course
you would need to customize your report(s) for this. Otherwise, if you are
ok showing the discount as a total at the end, GP will do that
automatically.
--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions - home of GP Reports
http://www.flex-solutions.com/gpreports.html
blog: http://www.victoriayudin.com

Post by lguifarro
we have a X-item the base list price listed as $100, but this price list,
the base one, is only use as a referral to other price lists that we
have.
So
if there's a price list for Supermarkets called, "SUPER A", and the
client
is
a supermarket obviously, this same X-item appears with a 90% of the price,
meaning that it's actual price is $90, but if there's another price
list
for
a special offer or sales, we have another list price called " ONSALE
B",
and
this X-Item is listed as 80% of the price, so that would be $80, so in theory
the sales price is 80% and you can say a $20 discount was given to the
customer.
Here is when things get weird, to my mind there was a discount given to the
customer for $20 but as usual GP disagrees with me(damned you GP, i know
best, LOL), in the accounts distributions, when I check the account for
discounts, is in zero, meaning that GP does not considered the $20 as a
discount but something else. And you can guess the type of havoc this has
caused in accounting.
I don't know if what we are doing so far, with the many price list, is right
or wrong but in order to solve my current situation I tought of a possible
way to do this. As far as i know, the only discount that GP treats as
discount perse, is the one you type individually for each item in a
line
of a
SOP, then in the discount window were you specified ,either a
percentage
or
an amount, it's reduced from the price and there you go. So is there a way
to populate this in a form somewhere in GP, the "markdown entry
window",
or
something so i'll specify the discount percent for each item, and in
the
case
when the customer got a special discount set priorities, where first check
the customer then the offers and then the item, or something similar, please
let me know.
Any help is appreciated
Regards
Luis

...

[Richard Whaley -- MVP 2006-2008]

Im wondering why you can't write a report showing the items sold (from sales
transaction history), the price charged, and the list price from inventory
(iv00106?). If you are using price sheets, then you would need to match the
price sold potentially against the price sheet.

I have done this several times for firms that wanted to know who was
discounting sales to whom!

Once you get the discount amount, you can sort the report by item and group
by account number index from the inventory table to get the data grouped for
manual postings.
--
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users

Get our Free Tips and Tricks Newsletter and check out our books at
http://www.AccoladePublications.com

Post by lguifarro
thanks for you reply.
The thing is that we have several accounts for discount for all the items,
for example, when we sell Johnie Walker, there's a account called, "Johnie
Walker Sales", and "Johnie Walker Discounts", and so on, for the rest of the
items. That's why i'm looking of a way to automatically populate the markdown
so when we sell this the discount automacally goes for it's respective
account. I know that in order to mantain this i'll have to do some VBA to
create perhaps a form so people can, in case it varies, mantain the proper
discounts percentages for the items.
Also where do you set the mark down for the items in GP, or the markdowns??
Regards
Luis

Post by Victoria [MVP]
Luis,
You're right, if the price list reflects the 'discounted' price, there is
nowhere in GP that it keeps track of the discount. The markdown
accomplishes what you want by creating a separate GL distribution for the
discount, but out-of-the-box you have to populate that manually.
One other option I have used, if the discount doesn't need to be tracked in
different GL accounts depending on item, is Trade Discount. For example,
you know that Customers in class SUPERMARKET always get 10% off. Enter the
trade discount on the Customer Card (or enter it on the class and roll it
down, if you are using classes). When you enter an SOP transaction, the
trade discount will be calculated automatically. If there is a special in
place, and you want to show that separately, you can still enter an
additional markdown, but that should now be an exception.
The trade discount actually gets calculated by line item in the SOP tables,
so if you need to show this by line item on invoices, you can - of course
you would need to customize your report(s) for this. Otherwise, if you are
ok showing the discount as a total at the end, GP will do that
automatically.
--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions - home of GP Reports
http://www.flex-solutions.com/gpreports.html
blog: http://www.victoriayudin.com

Post by lguifarro
we have a X-item the base list price listed as $100, but this price list,
the base one, is only use as a referral to other price lists that we have. So
if there's a price list for Supermarkets called, "SUPER A", and the client is
a supermarket obviously, this same X-item appears with a 90% of the price,
meaning that it's actual price is $90, but if there's another price list for
a special offer or sales, we have another list price called " ONSALE B", and
this X-Item is listed as 80% of the price, so that would be $80, so in theory
the sales price is 80% and you can say a $20 discount was given to the
customer.
Here is when things get weird, to my mind there was a discount given to the
customer for $20 but as usual GP disagrees with me(damned you GP, i know
best, LOL), in the accounts distributions, when I check the account for
discounts, is in zero, meaning that GP does not considered the $20 as a
discount but something else. And you can guess the type of havoc this has
caused in accounting.
I don't know if what we are doing so far, with the many price list, is right
or wrong but in order to solve my current situation I tought of a possible
way to do this. As far as i know, the only discount that GP treats as
discount perse, is the one you type individually for each item in a line of a
SOP, then in the discount window were you specified ,either a percentage or
an amount, it's reduced from the price and there you go. So is there a way
to populate this in a form somewhere in GP, the "markdown entry window", or
something so i'll specify the discount percent for each item, and in the case
when the customer got a special discount set priorities, where first check
the customer then the offers and then the item, or something similar, please
let me know.
Any help is appreciated
Regards
Luis

...

[lguifarro]

Thanks for your reply:

The thing is that what we want is to automatically update the markdown as
the lines in the SOP are entered, because it's the only discount GP accepts.
As I've said in my question the difference between the actual price, and the
base price in the price sheets, which i consider a discount, does not get
posted to it's respective accounts in GL, and after severals test that I've
done only when you manually input the markdown for the line item in the SOP
it does get posted as discount. That's why I'm looking for a way to do this.

Regards

Luis

I'm wondering why you can't write a report showing the items sold (from sales
transaction history), the price charged, and the list price from inventory
(iv00106?). If you are using price sheets, then you would need to match the
price sold potentially against the price sheet.
I have done this several times for firms that wanted to know who was
discounting sales to whom!
Once you get the discount amount, you can sort the report by item and group
by account number index from the inventory table to get the data grouped for
manual postings.
--
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
http://www.AccoladePublications.com

Post by lguifarro
thanks for you reply.
The thing is that we have several accounts for discount for all the items,
for example, when we sell Johnie Walker, there's a account called, "Johnie
Walker Sales", and "Johnie Walker Discounts", and so on, for the rest of the
items. That's why i'm looking of a way to automatically populate the markdown
so when we sell this the discount automatically goes for it's respective
account. I know that in order to maintain this I'll have to do some VBA to
create perhaps a form so people can, in case it varies, maintain the proper
discounts percentages for the items.
Also where do you set the mark down for the items in GP, or the markdowns??
Regards
Luis

Post by Victoria [MVP]
Luis,
You're right, if the price list reflects the 'discounted' price, there is
nowhere in GP that it keeps track of the discount. The markdown
accomplishes what you want by creating a separate GL distribution for the
discount, but out-of-the-box you have to populate that manually.
One other option I have used, if the discount doesn't need to be tracked in
different GL accounts depending on item, is Trade Discount. For example,
you know that Customers in class SUPERMARKET always get 10% off. Enter the
trade discount on the Customer Card (or enter it on the class and roll it
down, if you are using classes). When you enter an SOP transaction, the
trade discount will be calculated automatically. If there is a special in
place, and you want to show that separately, you can still enter an
additional markdown, but that should now be an exception.
The trade discount actually gets calculated by line item in the SOP tables,
so if you need to show this by line item on invoices, you can - of course
you would need to customize your report(s) for this. Otherwise, if you are
ok showing the discount as a total at the end, GP will do that
automatically.
--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions - home of GP Reports
http://www.flex-solutions.com/gpreports.html
blog: http://www.victoriayudin.com

Post by lguifarro
we have a X-item the base list price listed as $100, but this price list,
the base one, is only use as a referral to other price lists that we have. So
if there's a price list for Supermarkets called, "SUPER A", and the client is
a supermarket obviously, this same X-item appears with a 90% of the price,
meaning that it's actual price is $90, but if there's another price list for
a special offer or sales, we have another list price called " ONSALE B", and
this X-Item is listed as 80% of the price, so that would be $80, so in theory
the sales price is 80% and you can say a $20 discount was given to the
customer.
Here is when things get weird, to my mind there was a discount given to the
customer for $20 but as usual GP disagrees with me(damned you GP, i know
best, LOL), in the accounts distributions, when I check the account for
discounts, is in zero, meaning that GP does not considered the $20 as a
discount but something else. And you can guess the type of havoc this has
caused in accounting.
I don't know if what we are doing so far, with the many price list, is right
or wrong but in order to solve my current situation I tought of a possible
way to do this. As far as i know, the only discount that GP treats as
discount perse, is the one you type individually for each item in a line of a
SOP, then in the discount window were you specified ,either a percentage or
an amount, it's reduced from the price and there you go. So is there a way
to populate this in a form somewhere in GP, the "markdown entry window", or
something so i'll specify the discount percent for each item, and in the case
when the customer got a special discount set priorities, where first check
the customer then the offers and then the item, or something similar, please
let me know.
Any help is appreciated
Regards
Luis

...