Month End AP & GL Discrepancy - Single Sided Journal Entry?

Yahoo Archive
1
A one sided JE is easy at least in Vantage and unfortunately we have had to do it numerous times.

Go to Company Configuration, Modules, Finance, General Ledger
Check the box that says "Allow unbalanced manual general journal entries"
Click Save
Got to Journal Entry screen and enter data as normal - you will only have one line instead of two obviously
When hit post, system will ask you to override the journal entry since it is unbalanced, check OK
Verify the general ledger is in balance
Go to company configuration and uncheck the journal entry box, click save



CONFIDENTIALITY NOTICE: Internet and e-mail communications are property of Bruno Independent Living Aids. BILA reserves the right to retrieve, read and store any message created, sent or received. BILA reserves the right to monitor messages by authorized BILA employees at any time without any further consent.


[Non-text portions of this message have been removed]
2
....Vantage 8.03.409C Progress....



Morning,



I have a scenario where I have one Check that paid 3 Invoices (for the same
Supplier, obviously). Each Invoice had a Prompt Payment Discount. On one
of the 3 Invoices, the discount never hit the GL for some strange reason
causing the GL to not balance out for last month.



In Payment Tracker, Check #12345 on 6/19 correctly shows the full check
payment of $3000. And it also accurately shows each of the 3 Invoices with
the Prompt Payment Discount applied to each. OK...



In Supplier Tracker, (Payments tab) Check #12345 is listed on 6/19
correctly. HOWEVER, on the List tab, it incorrectly displays the full check
amount and only shows $398 (vs the correct $3000). $398 was the total of 1
of the 3 invoices for this check. I think this is a bug in the List Tab (no
big deal, really) because all 3 Invoices are shown on the Checks tab. even
though there was only one check cut. Weird. For some reason it seems to
think/display that there were 3 checks when in fact there was only one.??



The Check Register/Payment Register Report shows Check #12345 but, like
above, only lists the check amount as $398 instead of the full $3000.
Strange.



So then I flip to AP Invoice Tracker for each of the 3 Invoices: Invoice
#'s 001, 002 and 003. Each Invoice Header shows the correct full invoice
amount and Prompt Payment Discount. 2 of the 3 invoices correctly show the
respective GL Transactions hitting the right accounts and summing to the
full amount of the Invoice.



The problem seems to be with Invoice #003: It shows the correct GL
transactions EXCEPT it doesn't show the Prompt Payment Discount GL
transaction (like the other 2 Invoices). This is what is throwing our GL
balance off for Month End.



I somewhat don't care about the display discrepancies between Payment
Tracker and the Check Register Report and Supplier Tracker, although it is
frustrating and confusing.



What I *am* concerned about is how the Prompt Payment Discount didn't hit
the GL for the one Invoice and, furthermore, how to fix it.



I called support and Monterrey answered and I immediately knew I was pi$$ing
into the wind. He couldn't tell me why the discrepancies were happening
among the various trackers/reports but *did* say that I could fix this with
a "Single Sided Journal Entry". He was going to email me step-by-step
directions.. but guess what? They never arrived and he never replied to my
follow-up emails. If Epicor Support or Rhonda Spah is lurking, his name is
Emmanuel Rodriguez and my site ID is 96656 and Call# 2923084ESC.



I've never heard of a "Single Sided Journal Entry". Have any of you? And
if you have, how can I fix this??



TIA for your time!!





Vic






-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2195 / Virus Database: 2437/5127 - Release Date: 07/12/12

[Non-text portions of this message have been removed]
3
Ok all I know is that it is possible to do this but only if you have checked the Allow single sided entries in company config.

How you do it and what you do is beyond me....



M. Manasa Reddy
manasa@...<mailto:manasa@...>
630.806.2000 x1515

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Thursday, July 12, 2012 8:11 AM
To: Vantage Yahoo
Subject: [Vantage] Month End AP & GL Discrepancy - Single Sided Journal Entry?



....Vantage 8.03.409C Progress....

Morning,

I have a scenario where I have one Check that paid 3 Invoices (for the same
Supplier, obviously). Each Invoice had a Prompt Payment Discount. On one
of the 3 Invoices, the discount never hit the GL for some strange reason
causing the GL to not balance out for last month.

In Payment Tracker, Check #12345 on 6/19 correctly shows the full check
payment of $3000. And it also accurately shows each of the 3 Invoices with
the Prompt Payment Discount applied to each. OK...

In Supplier Tracker, (Payments tab) Check #12345 is listed on 6/19
correctly. HOWEVER, on the List tab, it incorrectly displays the full check
amount and only shows $398 (vs the correct $3000). $398 was the total of 1
of the 3 invoices for this check. I think this is a bug in the List Tab (no
big deal, really) because all 3 Invoices are shown on the Checks tab. even
though there was only one check cut. Weird. For some reason it seems to
think/display that there were 3 checks when in fact there was only one.??

The Check Register/Payment Register Report shows Check #12345 but, like
above, only lists the check amount as $398 instead of the full $3000.
Strange.

So then I flip to AP Invoice Tracker for each of the 3 Invoices: Invoice
#'s 001, 002 and 003. Each Invoice Header shows the correct full invoice
amount and Prompt Payment Discount. 2 of the 3 invoices correctly show the
respective GL Transactions hitting the right accounts and summing to the
full amount of the Invoice.

The problem seems to be with Invoice #003: It shows the correct GL
transactions EXCEPT it doesn't show the Prompt Payment Discount GL
transaction (like the other 2 Invoices). This is what is throwing our GL
balance off for Month End.

I somewhat don't care about the display discrepancies between Payment
Tracker and the Check Register Report and Supplier Tracker, although it is
frustrating and confusing.

What I *am* concerned about is how the Prompt Payment Discount didn't hit
the GL for the one Invoice and, furthermore, how to fix it.

I called support and Monterrey answered and I immediately knew I was pi$$ing
into the wind. He couldn't tell me why the discrepancies were happening
among the various trackers/reports but *did* say that I could fix this with
a "Single Sided Journal Entry". He was going to email me step-by-step
directions.. but guess what? They never arrived and he never replied to my
follow-up emails. If Epicor Support or Rhonda Spah is lurking, his name is
Emmanuel Rodriguez and my site ID is 96656 and Call# 2923084ESC.

I've never heard of a "Single Sided Journal Entry". Have any of you? And
if you have, how can I fix this??

TIA for your time!!

Vic

-----
No virus found in this message.
Checked by AVG - www.avg.com<http://www.avg.com>
Version: 2012.0.2195 / Virus Database: 2437/5127 - Release Date: 07/12/12

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
4
Once you have checked "Allow unbalanced Manual General Journal Entries" in company config. under Finance\General Ledger, it is just like entering any other general journal entry except your journal will only have 1 line and will be out of balance.

HTH,
Virginia Joseph
Deep Hole Specialsits

--- In vantage@yahoogroups.com, Manasa Reddy <manasa@...> wrote:
>
> Ok all I know is that it is possible to do this but only if you have checked the Allow single sided entries in company config.
>
> How you do it and what you do is beyond me....
>
>
>
> M. Manasa Reddy
> manasa@...<mailto:manasa@...>
> 630.806.2000 x1515
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
> Sent: Thursday, July 12, 2012 8:11 AM
> To: Vantage Yahoo
> Subject: [Vantage] Month End AP & GL Discrepancy - Single Sided Journal Entry?
>
>
>
> ....Vantage 8.03.409C Progress....
>
> Morning,
>
> I have a scenario where I have one Check that paid 3 Invoices (for the same
> Supplier, obviously). Each Invoice had a Prompt Payment Discount. On one
> of the 3 Invoices, the discount never hit the GL for some strange reason
> causing the GL to not balance out for last month.
>
> In Payment Tracker, Check #12345 on 6/19 correctly shows the full check
> payment of $3000. And it also accurately shows each of the 3 Invoices with
> the Prompt Payment Discount applied to each. OK...
>
> In Supplier Tracker, (Payments tab) Check #12345 is listed on 6/19
> correctly. HOWEVER, on the List tab, it incorrectly displays the full check
> amount and only shows $398 (vs the correct $3000). $398 was the total of 1
> of the 3 invoices for this check. I think this is a bug in the List Tab (no
> big deal, really) because all 3 Invoices are shown on the Checks tab. even
> though there was only one check cut. Weird. For some reason it seems to
> think/display that there were 3 checks when in fact there was only one.??
>
> The Check Register/Payment Register Report shows Check #12345 but, like
> above, only lists the check amount as $398 instead of the full $3000.
> Strange.
>
> So then I flip to AP Invoice Tracker for each of the 3 Invoices: Invoice
> #'s 001, 002 and 003. Each Invoice Header shows the correct full invoice
> amount and Prompt Payment Discount. 2 of the 3 invoices correctly show the
> respective GL Transactions hitting the right accounts and summing to the
> full amount of the Invoice.
>
> The problem seems to be with Invoice #003: It shows the correct GL
> transactions EXCEPT it doesn't show the Prompt Payment Discount GL
> transaction (like the other 2 Invoices). This is what is throwing our GL
> balance off for Month End.
>
> I somewhat don't care about the display discrepancies between Payment
> Tracker and the Check Register Report and Supplier Tracker, although it is
> frustrating and confusing.
>
> What I *am* concerned about is how the Prompt Payment Discount didn't hit
> the GL for the one Invoice and, furthermore, how to fix it.
>
> I called support and Monterrey answered and I immediately knew I was pi$$ing
> into the wind. He couldn't tell me why the discrepancies were happening
> among the various trackers/reports but *did* say that I could fix this with
> a "Single Sided Journal Entry". He was going to email me step-by-step
> directions.. but guess what? They never arrived and he never replied to my
> follow-up emails. If Epicor Support or Rhonda Spah is lurking, his name is
> Emmanuel Rodriguez and my site ID is 96656 and Call# 2923084ESC.
>
> I've never heard of a "Single Sided Journal Entry". Have any of you? And
> if you have, how can I fix this??
>
> TIA for your time!!
>
> Vic
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com<http://www.avg.com>
> Version: 2012.0.2195 / Virus Database: 2437/5127 - Release Date: 07/12/12
>
> [Non-text portions of this message have been removed]
>
>
>
> [Non-text portions of this message have been removed]
>