Hi Meng,
Did you try the manual process that I suggested for the lines marked red aafter the validate journal ???
Regs
Jim
Koh Meng <[EMAIL PROTECTED]> wrote:
Koh Meng <[EMAIL PROTECTED]> wrote:
Hi Jim and Girish,Attached is my posting errors. The thing i find it strange is that my GL Journal has 1005 lines but only certain lines got this error.Appreciate for any feedback.
Jim Jo <[EMAIL PROTECTED]> wrote:Hi Girish,Thats true that you have said. But really I ahve not gone though these tables :). Yep you are rit that when you use the general journal for opening balances before go live .. after the import you will get a lot of validation errors. but i dont find it really good to ask the user to enter the transactions manually when they have junk of data!.If you are very sure that your credit/ debit balances then the error is mainly of data that has been caused by axaptas excel import. Belive me I just did the same 3 days back .. yep after the excel import to the lines there were a lot of errors .. but I was able to get rid of all those errors in less than 2 hours. Some of the clues that I got I have already posted. hope you have read that. This may not be the right way to do it, but am sure this is the easiest way to do it!.Amount too little is a strange error, it has nothing to do with your setup. I got the same error. What i did was ,identified the line, jus modified the line , then again reset it back to the original. After that validate again . .ERROR is gone. I really suspect this is cuz of some update that didnt happen during the import. But you did a modify something got updated and it all went right!! . I would liek to investigate what happened , but always as usuall there is not time for that. New new issues comes up daily. Fun trouble shooting all.!!Jack please keep posted of errors !! if you still have. Would be able to give some suggestions !!!RegardsJim
Girish B <[EMAIL PROTECTED]> wrote:Hi Jim,
May be you could import the transactions directly
and post but I had tried in a few times and kept
getting errors.
When I see the “LedgerjournalTransDaily” table, I see
that there is one more table in the datasource
“CustVendPaymJournalFee” . I don’t know exactly what
is saved in this table because when I checked it
through the table browser it shows empty.
When I check the way the line is created
manually the system uses the LedgerJournalEngine
(class) to check and calculate the data for the
LedgerJournalTrans table. I remember I had used the
same way to populate the table.
If we can successfully post after importing the
lines then it would be the best thing.
Jack, if you succeed in posting the journals do
let us know what else you needed to do to solve the
problem, it would be useful to all of us.
Cheers,
Girish
--- Jim Jo <[EMAIL PROTECTED]> wrote:
> How many of your vouchers are marked red ???
> Is it possible for you manually modify and save
> those vouchers from axapta?
> If so do this. For ex if the credit amount of the
> voucher is 100. delete the 100 and save. Then again
> enter the 100 and save. Then do a validate again.
> This is a data error caused on import. I had faced
> the same errors.
>
> Hope it helps
>
> Jim
>
> Koh Meng <[EMAIL PROTECTED]> wrote:
> Hi Jim,
>
> Thanks for your prompt reply. I've check the
> transaction total using sql and i find the total
> debit and credit are balance and tally to each
> other.
>
> Actually what does 'amount too little' mean? I've
> checked those vouchers marked in red and i found all
> the vouchers are ok and they have the same values
> with those posted vouchers (i checked it at the
> backend).
>
> I really don't have any idea what's turn out to be
> wrong. Please help.
>
> Jim Jo <[EMAIL PROTECTED]> wrote:
> Seems like your vouchers does not balance .. credit
> and debit must balance in a double entry system!
> check that first.
> And the amount too little is jus another data error.
> You have to identify the vouchers which are marked
> red. Then jus modify and save the vouchers. That
> will do !.
>
> If you still have problems do lemme know!
>
> Regards
>
> Jim.
>
> Koh Meng <[EMAIL PROTECTED]> wrote:
> Hi all,
> I'm in the midst of doing GL data migration using
> Axapta Excel Template (LedgerJournalTable and
> LedgerJournalTrans). After I loaded the GL Opening
> Balances into General Journal and tried to do the
> posting, an error message threw out and stopped me
> from posting (see attached).
>
> Can anyone help me to solve it? Thousands thanks in
> advance.
>
>
> Best Regards,
>
> Jack Koh
>
>
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail Address AutoComplete - You start. We
> finish.
>
> Sharing the knowledge on Axapta.
>
>
>
>
> > ATTACHMENT part 2 application/msword name=Posting
> Errors.doc
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail Address AutoComplete - You start. We
> finish.
>
> Sharing the knowledge on Axapta.
>
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail - Helps protect you from nasty viruses.
>
> Sharing the knowledge on Axapta.
>
>
> Yahoo! Groups SponsorADVERTISEMENT
>
>
> ---------------------------------
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
>
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail - Helps protect you from nasty viruses.
Send instant messages to your online friends http://uk.messenger.yahoo.com
Sharing the knowledge on Axapta.
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
Sharing the knowledge on Axapta.
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
Sharing the knowledge on Axapta.
> ATTACHMENT part 2 application/msword name=Posting Error.doc
Do you Yahoo!?
Express yourself with Y! Messenger! Free. Download now.
Sharing the knowledge on Axapta.
| Yahoo! Groups Sponsor |
| Get unlimited calls to U.S./Canada |
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
