Thanks for the answers to the previous post.  We are now approx. 2 weeks 
behind in entries for Dynamics.  I was hoping to delegate the transaction 
entry among 2 clerks.  I was going to have #1 enter transactions from 
Realworld for odd days and #2 enter transactions for even days.  However, the 
check number does not allow for concurrent entry, i.e. we can't advance the 
check number for #2 to enter checks prior to #1 entering the checks for the 
prior day.

Is there a workaround?  I am thinking of running a bogus checkbook and close 
out the account to the real checkbook's account once we are caught up.  The 
check #s will match the actual check written and we will understand the the 
bogus cash account/checkbook.

Any thoughts?

thanks,
-- 
Phil Gilbert
Free Radical, LTD.

Phil,

What exactly is the end result you want to accomplish?  Just getting
the check data into GP or do you also need the vendor invoice in GP
along with the account distribution?  If it's the former, you could
just import the check data into the checkbook register and be done
with it.

Frank Hamelly
MCP-GP, MCT, MVP
East Coast Dynamics
www.eastcoast-dynamics.com

Phil,

Why can't they just type in the actual check number?  Go to Cards > 
Financial > Checkbook, find your checkbook and check the box on the bottom 
right to allow Override Check Number.  I would recommend this over creating 
a bogus checkbook as you'll not be able to reconcile the bogus checkbook and 
the real checkbook together.

-- 
Victoria Yudin
Dynamics GP MVP
Flexible Solutions - home of GP Reports
http://www.flex-solutions.com/gpreports.html
blog: www.victoriayudin.com


"frdbadf" <frdbadf@discussions.microsoft.com> wrote in message 
news:CFA14D26-4FA7-4085-B310-93C9486BBC32@microsoft.com...
> Thanks for the answers to the previous post.  We are now approx. 2 weeks
> behind in entries for Dynamics.  I was hoping to delegate the transaction
> entry among 2 clerks.  I was going to have #1 enter transactions from
> Realworld for odd days and #2 enter transactions for even days.  However, 
> the
> check number does not allow for concurrent entry, i.e. we can't advance 
> the
> check number for #2 to enter checks prior to #1 entering the checks for 
> the
> prior day.
>
> Is there a workaround?  I am thinking of running a bogus checkbook and 
> close
> out the account to the real checkbook's account once we are caught up. 
> The
> check #s will match the actual check written and we will understand the 
> the
> bogus cash account/checkbook.
>
> Any thoughts?
>
> thanks,
> -- 
> Phil Gilbert
> Free Radical, LTD. 

Thanks for the replies.  We are just trying to get caught up this month.   We 
want vendor balances for the 1099s....  I think Victoria has the solution 
with the check number override, (Frank may have alluded to this in the 
previous topic).

Thanks to both of you and Mariano's suggestion about the Miscellaneous Check.

Mariano, to track the Vendor Balances we would still need to post the 
invoices in AP.  However we don't often pay alll payables by Due date... 
Miscellenous check will be great for our Temp Vendors, but to provide vendor 
history wouldn't the AP Transaction Entry be the easiest?

thanks again.
-- 
Phil Gilbert
Free Radical, LTD.


"Victoria [MVP]" wrote:

> Phil,
> 
> Why can't they just type in the actual check number?  Go to Cards > 
> Financial > Checkbook, find your checkbook and check the box on the bottom 
> right to allow Override Check Number.  I would recommend this over creating 
> a bogus checkbook as you'll not be able to reconcile the bogus checkbook and 
> the real checkbook together.
> 
> -- 
> Victoria Yudin
> Dynamics GP MVP
> Flexible Solutions - home of GP Reports
> http://www.flex-solutions.com/gpreports.html
> blog: www.victoriayudin.com
> 
> 
> "frdbadf" <frdbadf@discussions.microsoft.com> wrote in message 
> news:CFA14D26-4FA7-4085-B310-93C9486BBC32@microsoft.com...
> > Thanks for the answers to the previous post.  We are now approx. 2 weeks
> > behind in entries for Dynamics.  I was hoping to delegate the transaction
> > entry among 2 clerks.  I was going to have #1 enter transactions from
> > Realworld for odd days and #2 enter transactions for even days.  However, 
> > the
> > check number does not allow for concurrent entry, i.e. we can't advance 
> > the
> > check number for #2 to enter checks prior to #1 entering the checks for 
> > the
> > prior day.
> >
> > Is there a workaround?  I am thinking of running a bogus checkbook and 
> > close
> > out the account to the real checkbook's account once we are caught up. 
> > The
> > check #s will match the actual check written and we will understand the 
> > the
> > bogus cash account/checkbook.
> >
> > Any thoughts?
> >
> > thanks,
> > -- 
> > Phil Gilbert
> > Free Radical, LTD. 
> 
> 

On Oct 22, 2:48=A0pm, frdbadf <frdb...@discussions.microsoft.com> wrote:
> Thanks for the replies. =A0We are just trying to get caught up this month=
.. =A0 We
> want vendor balances for the 1099s.... =A0I think Victoria has the soluti=
on
> with the check number override, (Frank may have alluded to this in the
> previous topic).
>
> Thanks to both of you and Mariano's suggestion about the Miscellaneous Ch=
eck.
>
> Mariano, to track the Vendor Balances we would still need to post the
> invoices in AP. =A0However we don't often pay alll payables by Due date..=
..
> Miscellenous check will be great for our Temp Vendors, but to provide ven=
dor
> history wouldn't the AP Transaction Entry be the easiest?
>
> thanks again.
> --
> Phil Gilbert
> Free Radical, LTD.
>
>
>
> "Victoria [MVP]" wrote:
> > Phil,
>
> > Why can't they just type in the actual check number? =A0Go to Cards >
> > Financial > Checkbook, find your checkbook and check the box on the bot=
tom
> > right to allow Override Check Number. =A0I would recommend this over cr=
eating
> > a bogus checkbook as you'll not be able to reconcile the bogus checkboo=
k and
> > the real checkbook together.
>
> > --
> > Victoria Yudin
> > Dynamics GP MVP
> > Flexible Solutions - home of GP Reports
> >http://www.flex-solutions.com/gpreports.html
> > blog:www.victoriayudin.com
>
> > "frdbadf" <frdb...@discussions.microsoft.com> wrote in message
> >news:CFA14D26-4FA7-4085-B310-93C9486BBC32@microsoft.com...
> > > Thanks for the answers to the previous post. =A0We are now approx. 2 =
weeks
> > > behind in entries for Dynamics. =A0I was hoping to delegate the trans=
action
> > > entry among 2 clerks. =A0I was going to have #1 enter transactions fr=
om
> > > Realworld for odd days and #2 enter transactions for even days. =A0Ho=
wever,
> > > the
> > > check number does not allow for concurrent entry, i.e. we can't advan=
ce
> > > the
> > > check number for #2 to enter checks prior to #1 entering the checks f=
or
> > > the
> > > prior day.
>
> > > Is there a workaround? =A0I am thinking of running a bogus checkbook =
and
> > > close
> > > out the account to the real checkbook's account once we are caught up=
..
> > > The
> > > check #s will match the actual check written and we will understand t=
he
> > > the
> > > bogus cash account/checkbook.
>
> > > Any thoughts?
>
> > > thanks,
> > > --
> > > Phil Gilbert
> > > Free Radical, LTD.- Hide quoted text -
>
> - Show quoted text -

I'm going to approach the outside the box view.

Are you re-entering invoices in GP that exist in RW? Why not have
these invoices imported into GP?
You can upload detail invoices and then run Select Payables Checks for
those vendors.

Just pay multiple invoices with one check per vendor and be done.

Unless I'm missing something else here.

Elmer

Phill,

Agree (on post to AP)! However, it seems you are creating more work for 
yourself with this approach. Normally, what you would do in these cases is 
perform all transactions in Realworld until you are ready to cut over. At the 
cutoff date, you would bring in all open vendor transactions into GP.

History would best be kept in Realworld and accessed when necessary. At 
year-end, when you are ready to provide 1099s, you will need to follow the 
payables closing procedures, then edit your 1099s to reflect the correct 
number for each 1099 vendor. This is only required once (on the first 
year-end closing in GP). 

If you still decide that bringing the detail will serve you best, then I 
would choose Integration Manager to import all vendor transaction records 
into the system and create a mail merged macro that will apply all 
transactions and amounts based on how they were applied in Realworld.

Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com


"frdbadf" wrote:

> Thanks for the replies.  We are just trying to get caught up this month.   We 
> want vendor balances for the 1099s....  I think Victoria has the solution 
> with the check number override, (Frank may have alluded to this in the 
> previous topic).
> 
> Thanks to both of you and Mariano's suggestion about the Miscellaneous Check.
> 
> Mariano, to track the Vendor Balances we would still need to post the 
> invoices in AP.  However we don't often pay alll payables by Due date... 
> Miscellenous check will be great for our Temp Vendors, but to provide vendor 
> history wouldn't the AP Transaction Entry be the easiest?
> 
> thanks again.
> -- 
> Phil Gilbert
> Free Radical, LTD.
> 
> 
> "Victoria [MVP]" wrote:
> 
> > Phil,
> > 
> > Why can't they just type in the actual check number?  Go to Cards > 
> > Financial > Checkbook, find your checkbook and check the box on the bottom 
> > right to allow Override Check Number.  I would recommend this over creating 
> > a bogus checkbook as you'll not be able to reconcile the bogus checkbook and 
> > the real checkbook together.
> > 
> > -- 
> > Victoria Yudin
> > Dynamics GP MVP
> > Flexible Solutions - home of GP Reports
> > http://www.flex-solutions.com/gpreports.html
> > blog: www.victoriayudin.com
> > 
> > 
> > "frdbadf" <frdbadf@discussions.microsoft.com> wrote in message 
> > news:CFA14D26-4FA7-4085-B310-93C9486BBC32@microsoft.com...
> > > Thanks for the answers to the previous post.  We are now approx. 2 weeks
> > > behind in entries for Dynamics.  I was hoping to delegate the transaction
> > > entry among 2 clerks.  I was going to have #1 enter transactions from
> > > Realworld for odd days and #2 enter transactions for even days.  However, 
> > > the
> > > check number does not allow for concurrent entry, i.e. we can't advance 
> > > the
> > > check number for #2 to enter checks prior to #1 entering the checks for 
> > > the
> > > prior day.
> > >
> > > Is there a workaround?  I am thinking of running a bogus checkbook and 
> > > close
> > > out the account to the real checkbook's account once we are caught up. 
> > > The
> > > check #s will match the actual check written and we will understand the 
> > > the
> > > bogus cash account/checkbook.
> > >
> > > Any thoughts?
> > >
> > > thanks,
> > > -- 
> > > Phil Gilbert
> > > Free Radical, LTD. 
> > 
> > 

Thanks Mariano, your help and posts have been very insightful.  We had all 
our Realworld data converted thru our FY which ended Jun 30, and 1st Qtr of 
the new FY which ended 09/30.

We have 60 branches and were overwhelmed with the 1st of the month and 
cutting last month P&Ls for company wide and individual profit centers which 
we completed yesterday.  I showed the 2 clerks this afternoon the transaction 
entry and they were relieved by the ease of entry.  We have the time between 
now and end of month and it is a good orientation drill for the AP clerks.

Your advice is greatly appreciated.

thanks,,
-- 
Phil Gilbert
Free Radical, LTD.


"Mariano Gomez" wrote:

> Phill,
> 
> Agree (on post to AP)! However, it seems you are creating more work for 
> yourself with this approach. Normally, what you would do in these cases is 
> perform all transactions in Realworld until you are ready to cut over. At the 
> cutoff date, you would bring in all open vendor transactions into GP.
> 
> History would best be kept in Realworld and accessed when necessary. At 
> year-end, when you are ready to provide 1099s, you will need to follow the 
> payables closing procedures, then edit your 1099s to reflect the correct 
> number for each 1099 vendor. This is only required once (on the first 
> year-end closing in GP). 
> 
> If you still decide that bringing the detail will serve you best, then I 
> would choose Integration Manager to import all vendor transaction records 
> into the system and create a mail merged macro that will apply all 
> transactions and amounts based on how they were applied in Realworld.
> 
> Best regards,
> --
> MG.-
> Mariano Gomez, MIS, MCP, PMP
> Maximum Global Business, LLC
> http://www.maximumglobalbusiness.com
> The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> 
> 
> "frdbadf" wrote:
> 
> > Thanks for the replies.  We are just trying to get caught up this month.   We 
> > want vendor balances for the 1099s....  I think Victoria has the solution 
> > with the check number override, (Frank may have alluded to this in the 
> > previous topic).
> > 
> > Thanks to both of you and Mariano's suggestion about the Miscellaneous Check.
> > 
> > Mariano, to track the Vendor Balances we would still need to post the 
> > invoices in AP.  However we don't often pay alll payables by Due date... 
> > Miscellenous check will be great for our Temp Vendors, but to provide vendor 
> > history wouldn't the AP Transaction Entry be the easiest?
> > 
> > thanks again.
> > -- 
> > Phil Gilbert
> > Free Radical, LTD.
> > 
> > 
> > "Victoria [MVP]" wrote:
> > 
> > > Phil,
> > > 
> > > Why can't they just type in the actual check number?  Go to Cards > 
> > > Financial > Checkbook, find your checkbook and check the box on the bottom 
> > > right to allow Override Check Number.  I would recommend this over creating 
> > > a bogus checkbook as you'll not be able to reconcile the bogus checkbook and 
> > > the real checkbook together.
> > > 
> > > -- 
> > > Victoria Yudin
> > > Dynamics GP MVP
> > > Flexible Solutions - home of GP Reports
> > > http://www.flex-solutions.com/gpreports.html
> > > blog: www.victoriayudin.com
> > > 
> > > 
> > > "frdbadf" <frdbadf@discussions.microsoft.com> wrote in message 
> > > news:CFA14D26-4FA7-4085-B310-93C9486BBC32@microsoft.com...
> > > > Thanks for the answers to the previous post.  We are now approx. 2 weeks
> > > > behind in entries for Dynamics.  I was hoping to delegate the transaction
> > > > entry among 2 clerks.  I was going to have #1 enter transactions from
> > > > Realworld for odd days and #2 enter transactions for even days.  However, 
> > > > the
> > > > check number does not allow for concurrent entry, i.e. we can't advance 
> > > > the
> > > > check number for #2 to enter checks prior to #1 entering the checks for 
> > > > the
> > > > prior day.
> > > >
> > > > Is there a workaround?  I am thinking of running a bogus checkbook and 
> > > > close
> > > > out the account to the real checkbook's account once we are caught up. 
> > > > The
> > > > check #s will match the actual check written and we will understand the 
> > > > the
> > > > bogus cash account/checkbook.
> > > >
> > > > Any thoughts?
> > > >
> > > > thanks,
> > > > -- 
> > > > Phil Gilbert
> > > > Free Radical, LTD. 
> > > 
> > >